Thanks.



>>Using SQL Pass Through I issue the following command
>>
>>
>>LcSQL = " Select * from parts; Select * from titles "
>>LnResul = SQLExec(hConn, LcSQL)
>>
>>It creates 2 results set named “Sqlresult & Sqlresult1”
>>
>>Is there a way to name the results sets with specific aliases??
>
>You can use USE ... AGAIN

USE (DBF(Sqlresult)) AGAIN ALIAS crsParts IN 0
>USE (DBF(Sqlresult1)) AGAIN ALIAS crsTitles IN 0
>USE IN Sqlresult
>USE IN Sqlresult1

>
>You can also specify the name for the first cursor as a third parameter to SQLExEC(). The second cursor would have the same name plus "1" and so on.