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--