=SqlExec(myHandle, "Select * from MyTable", "MyTable") PlayWithMyTable() ScanMyTable() Function PlayWithMyTable *--- Do some stuff Use In MyTable Endfunc Function ScanMyTable try *-- In the program here i expect the cursor to be there *-- but some other functions may have closed it Scan &&&& Open dialog box *--- Some code here EndScan catch ... EndFunc>From the code shown, a SELECT is being issued, which will always go against a Fox table or cursor. If you want to get data from SQL Server, you need to use a remote view, SPT, or a Cursor Adapter and have the SELECT passed to SQL Server.
>>try >> *-- In the program here i expect the cursor to be there >> *-- but some other functions may have closed it >> Scan &&&& Open dialog box >> *--- Some code here >> >> EndScan >>catch >>... >>>>