Information générale
Titre:
SQLEXEC and retrieving multipe record sets
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.
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