Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC Drivers for oracle...2 Questions:
Message
De
18/10/1999 23:12:03
Gregg Geeslin
Kwajalein Range Services
Apo, Californie, États-Unis
 
 
À
18/10/1999 08:24:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00277593
Message ID:
00277989
Vues:
24
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
Fil
Voir

Click here to load this message in the networking platform