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