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 > -1This 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?