Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query Causing Fatal Exception
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Query Causing Fatal Exception
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01062055
Message ID:
01062055
Views:
71
Hi all,

I have a custom form method that issues the following UPDATE statement involving two cursors:
UPDATE c_Store SET ;
		c_Store.nMin = c_MinMax.nMin ;
	FROM c_MinMax WITH (Buffering = .t.) ;
	WHERE c_Store.cGroup = c_MinMax.cGroup ;
		AND c_Store.lLock = .f. ;
		AND c_MinMax.nMin > -1
This has been working fine, but today in testing it started causing this on a pretty regular basis:
Fatal error: Exception code=C0000005 @ 10/25/2005 16:06:41. Error log file: c:\Program Files\Common Files\Microsoft Shared\VFP\vfp9rerr.log
	Called from -  frmstore.tmupdatestoreminmaxvalues line 7  {n:\testingsql\al\forms\frmstore.sct n:\testingsql\al\forms\frmstore.sct}
	Called from -  frmstore.cntstore.cmdapply.click line 2  {n:\testingsql\al\forms\frmstore.sct n:\testingsql\al\forms\frmstore.sct}
	Called from -  frmallocation.cmdsetup.click line 2  {n:\testingsql\al\forms\frmallocation.sct n:\testingsql\al\forms\frmallocation.sct}
	Called from -  ctralapp.readevents line 24  {n:\testingsql\xlib\xxfw.vct n:\testingsql\xlib\xxfw.vct}
	Called from -  xxfwmain line 662  {N:\TestingSQL\xlib\xxfwmain.prg xxfwmain.fxp}
	Called from -  almain line 78  {N:\TestingSQL\AL\programs\almain.prg n:\testingsql\al\al034.exe}
I don't see anything wrong with the query, but that's the line that keeps causing the problems. How do I even start to debug this?

TIA,
Chad
_________________________________
There are 2 types of people in the world:
    Those who need closure
Next
Reply
Map
View

Click here to load this message in the networking platform