Pass the cursor name as the 3 parameter in your SQLExec(). However, each subsequent cursor should be that name followed by a number.
>Using SQLEXEC how do I individually name the cursors that are returned in a multi record set query? I issue a statement such as:
>
>lcSQL = "Select * from customers;select * from employees"
>lnResults = SQLEXEC(1,lcSQL)
>
>When I issue this command I get back SQLRESULT1 and SQLRESULT.
>
>If I issue the command again as:
>
>lnResults = SQLEXEC(1,lcSQL,"Employees")
>
>I get back Employees1 and Employees
>
>The syntax does not seem to support something like:
>"SELECT * FROM Customers,'Customers';Select * from Employees,'Employees'"
>
>I also tried it directly:
>
>lnresult = SQLEXEC(1,select * from customers,"customers";select * from employees,"employees")
>
>No luck. Any ideas would be greatly appreciated.
Mark McCasland
Midlothian, TX USA