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