General information
Title:
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.
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