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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement