HI,
I've a large table (100K+ records that takes up about 75MB) that is giving me fits (C000000005 errors) when the follow is done:
SELECT lsealt
SET ORDER TO TAG lseacctnum
SET KEY TO m.lseacctnum && variable assigned a value
LOCATE
Usually the LOCATE causes the problem. But to make matters more confusing is that I don't get this when I use VFP6. Only when running the code in VFP7.
I've recreated indexes, copied the records to a Temp table and renamed it back. Nothing works. I don't want to compile under VFP6.
Anyone know about any quirks with SET KEY TO ?
Thanks
Gil Munk
"If a nation expects to be ignorant and free, it expects what never was and never will be." - Thomas Jefferson