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??
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement