Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLEXEC and retrieving multipe record sets
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SQLEXEC and retrieving multipe record sets
Miscellaneous
Thread ID:
00661239
Message ID:
00661239
Views:
60
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
Map
View

Click here to load this message in the networking platform