Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retriving multiple cursors, using SQL passthroughs.
Message
 
 
To
05/10/2001 14:11:04
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00564926
Message ID:
00564942
Views:
11
SQLEXEC(Handle,"select * from table1 select * from table2","cursor1")
The second cursor will have name cursor11 and so on.

>One of my co workers said that you can retrieve multiple cursors from one pass through.
>
>I have never seen this. The following example of one cursor:
>=SQLEXEC(Handle,"select * from table","cursor1") This will return cursor1.
>The above is the only way I return a cursor and it is only one.
>
>He says he has seen where ypu can create a passthrough and it will return CURSOR1,cursor2,cursor2.
>
>If anyone has done or seen this, please reply and send me an example.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform