LOCATE (with no condition) is usually faster than a GO TOP.


>Why are you using LOCATE after a SET KEY? GO TOP should be faster.
>
>>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