Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLEXEC and retrieving multipe record sets
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
SQLEXEC and retrieving multipe record sets
Divers
Thread ID:
00661239
Message ID:
00661239
Vues:
59
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
Fil
Voir

Click here to load this message in the networking platform