Its perfectly possible.
SQLExec(nHandle,"Select * From table1;Select * from table2","Cursor")
This is going to return Cursor and Cursor1
Beware if you use Cursor1 you will have Cursor1 and Cursor11
Also you can retrieve multiple cursors and output parameters if you are using stored procedures with SQL SErver.
The maximium that I tried were 17 cursor and It worked fine.
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only