Mike Yearwood
Toronto, Ontario, Canada
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement