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.
Précédent
Suivant
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