Hello Tim,
>Question 1:
>I am looking for an ODBC driver that supports ASYNCH for ORACLE..
I can't help you here....
>Question 2: Use of bind variables:
>I use bind variables quite often in my sql code:
>For example the following function call:
>
>SQLEXEC(gnconnectionhandle,"{Call UpdatePdmLog(?cinit,?cDB,?cType,?cMainkey,?cOldLinekey,?cNewLineKey,?cData,?cStatus1,?cStatus2,?cAdmStatus,?cAdmStatu2,?cAdmCode,?nRec)}")
Can't you concatenate the string before running it through SQLEXEC? I'm assuming that your bind variables are actually memory variables so you could...
LOCAL OracleString, Retval
OracleString = "{Call UpdatePdmLog('" + ALLTRIM(m.cinit) + '","' + ALLTRIM(m.cDB) + ... + "," + ALLTRIM(STR(m.nRec)) + ")}"
Retval = SQLEXEC(gnconnectionhandle,m.OracleString)
I've assembled SQL statements this way before. You might have to adjust the way of doing the concatenation to get it to work just right. I'm at home right now and don't have a way to test this.
Good Luck,
Gregg
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