Check to see IF USED('MyCursor')
>How can test that the SPT returned a valid cursor? I have my connect code then I do a If reccount() > 0 assign cursor data to parameters. I am getting misleading data in my app. Example: I opened the remote table for modifying. Then I ran the app that has the SPT and it didn't tell me the SQL statement didn't return a cursor just that the parameters I wanted to assign the cursor data to failed. The reccount() must be getting populated from the last opened table or cursor. Please help. I need to know if the remote table is not accessible and keep the app from proceding any further.
Mark McCasland
Midlothian, TX USA