Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC Drivers for oracle...2 Questions:
Message
From
18/10/1999 23:12:03
Gregg Geeslin
Kwajalein Range Services
Apo, California, United States
 
 
To
18/10/1999 08:24:00
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00277593
Message ID:
00277989
Views:
25
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
Map
View

Click here to load this message in the networking platform