As in Help:
SQLExec(hConn, LcSQL, CursorNAme)
*--------------------
CursorName
Specifies the name of the Visual FoxPro cursor to which the result set is sent. If you don't include a cursor name, Visual FoxPro uses the default name SQLRESULT.
For multiple result sets, new cursor names are derived by appending an incremented number to the name of the first cursor.
*----------------------------------
>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??
Previous
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