>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.
--sb--