Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
C0000005 Errors on SQLEXEC command
Message
From
28/01/2003 15:23:21
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
C0000005 Errors on SQLEXEC command
Miscellaneous
Thread ID:
00746409
Message ID:
00746409
Views:
60
Hi,
I am having serious problems with a consistant C0000005 error.
This error happens on one of the two commands (if I comment the first one out..) :

lnerror=SQLEXEC(oUserObj.Connhandle,"delete from "+gettable(cdb)+" where mainkey=?cNewKey and modulname=?lcModule")

lnerror=SQLEXEC(oUSerObj.Connhandle,"select * from "+gettable(cdb)+" where mainkey=?cOldKey and modulname=?lcModule","TCREATE")

The database connection is to oracle and the bind variables have values
and in fact change the sql does not make a difference. the connection
is valid and I tried SQLEXEC() and other variations (passing the sql string as lnerror=SQLEXEC(oUSerObj.Connhandle,lsql.. and SQLEXEC(h,lsql...

I am running VFP Sp1



Fatal error: Exception code=C0000005 @ 01/28/2003 21:16:56. Error log file: C:\Program Files\Microsoft Visual FoxPro 7\vfp7err.log
Called from - createrecords line 187 {d:\questpdm.ora\kernel\prg\copysele.prg d:\questpdm.ora\kernel\prg\copysele.fxp}
Called from - copysele line 32 {d:\questpdm.ora\kernel\prg\copysele.prg d:\questpdm.ora\kernel\prg\copysele.fxp}
Called from - copychilds line 42 {d:\questpdm.ora\kernel\prg\funcmod.prg d:\questpdm.ora\kernel\prg\funcmod.fxp}
Called from - l80802p5 line 71 {c:\docume~1\tjm\locals~1\temp\l80802p5.tmp c:\docume~1\tjm\locals~1\temp\l80802p5.fxp}
Called from - wstyles.runcode line 34 {d:\questpdm.ora\kernel\class\_controls.vct d:\questpdm.ora\kernel\class\_controls.vct}
Called from - wstyles.insteadofsave line 1 {d:\questpdm.ora\kernel\class\_controls.vct d:\questpdm.ora\kernel\class\_controls.vct}
Called from - wstyles.save line 27 {d:\questpdm.ora\kernel\screen\styles.sct d:\questpdm.ora\kernel\screen\styles.sct}
Called from - pdmtoolbar.nspeed_save.click line 10 {d:\questpdm.ora\kernel\class\styles.vct d:\questpdm.ora\kernel\class\styles.vct}
Called from - start line 131 {d:\questpdm.ora\kernel\prg\start.prg d:\questpdm.ora\kernel\prg\start.fxp}


Any ideas.. This one is really important
Next
Reply
Map
View

Click here to load this message in the networking platform