Kindly let me know if further details required. Thanks
It is very hard to figure out what exactly the logic behind you application, especially if getmydataByID.lastresult and getAllmydata() calls are invoked from your PHP or Flex. It will be great to see the full picture with code snippets.
As for your question, I would suggest to use the debugging tool, to better understand what information is retrieved per each call and by this pin point the logic of your application.
See this page for more information on debugging: http://files.zend.com/help/Flash-Builder-for-PHP/Help/debugging_a_flex_mobile_php_applicat ion.htm
Thanks for your reply and all the guidance. I have actually tried doing debug but wasn't able to find the issue. Let me try to explain the scenario. I just want to show all the columns with PatientID of 1024 into a datagrid. There is a function, which is created automatically at the time of creating a DataService and its called getmydataByID (where mydata is just the name I have given to my DataService and "get & ByID" are pre-defined keywords for this fuction). I have tried to use this function but this functions works like searching on the Primary key only, and as the values of PatientID is not unique, so I can't define it as primary key to get use of this function.
Can you please give me an idea that how can I achieve this?