Thanks Mark,
Yes, the naming of the 3rd parameter certainly gives an interesting result. If you leave it blank you get the result cursor named SQLResult, SQLResult1, .... SQLResultn. But, this seems to be problematic because SQL server may or may not return the cursor in the same order of the calling procedure order.
This seems like a great feature that saves connecting and executing multiple SQLEXECs to retreive multiple record sets. I guess I am not sure how to resolve the issue of the returned cursors' naming convention.
Regards and thanks,
Jim Smith
This seems like a great way to populate a
>Pass the cursor name as the 3 parameter in your SQLExec(). However, each subsequent cursor should be that name followed by a number.
>
>>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.
Previous
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