Dear Claudio:
You can name the cursor by putting the SELECTs in a variable and then passing as the third parameter the root name of the cursors. For example,
lcSQL = "SELECT * FROM EMPLOYEE;SELECT * FROM CUSTOMERS"
Then you can issue the SQLEXEC with the third parameter being the root name.
SQEXEC(1,lcSQL,"EMPLOYEE")
This return the result cursors:
Employee, Employee1
My problem with this is not the naming because I can just USE AGAIN EMPLOYEE1 ALIAS CUSTOMERS. It has to do with my confidence level with how SQL returns the cursor. If it is more efficient to retrieve the Customers tables before the employee table will the Customer table be employee and employee be employee1.
Sorry for the long wind but ... <s>
Regards,
Jim Smith
>>Using SQLEXEC how do I individually name the cursors that are returned in a multi record set query?
>
>AFAIK, you can´t.
Previous
Next
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