Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
C0000005 Errors on SQLEXEC command
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00755209
Message ID:
00791491
Views:
31
>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
Map
View

Click here to load this message in the networking platform