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