Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
C0000005 Errors on SQLEXEC command
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00755209
Message ID:
00791491
Vues:
30
>Tim, Did you ever get this resolved with the Oracle driver or did you just move to the Microsoft driver? We have an installation with 400 machines and we get this sporadically in the application. There seems to be no pattern to it.

Yes, Actually I did..
I found out the problem occurs when the bind variable is EMPTY() it needs to be NULL instead...

So what I do is replace the value in the bind variable before I use it something like:

lBVnErrRecord =IIF(EMPTY(lBVnErrRecord) OR ISNULL(lBVnErrRecord),NULL,lBVnErrRecord)
lcsql='INSERT INTO table (ErrDate....) values (?lBVnErrRecord..'
SQLEXEC(h,lcsql)

BR
Tim
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform