Mike Yearwood
Toronto, Ontario, Canada
See the response I just posted. SET KEY and SET FILTER are radically different IMO.
>That essentially is what a SET KEY is.
>
>
>>Only if a filter is in effect.
>>
>>>LOCATE 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
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