Message
From
12/04/2010 20:56:37
To
12/04/2010 20:52:31
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01459829
Message ID:
01459837
Views:
56
>>>>An index on pkfield ought to do it.
>>>>
>>>>What data type is pkfield?
>>>
>>>Correction. The field is Numeric(6,0) but there is an index tag on this field. Yet, Rushmore is not used.
>>
>>Try
>>
>Nope. This does not work either.
Check this thread How does TOP work? Thread #1362672
>>>>
>>>>What data type is pkfield?
>>>
>>>Correction. The field is Numeric(6,0) but there is an index tag on this field. Yet, Rushmore is not used.
>>
>>Try
>>
>>select * from myTable where pkfield IN (select top 100 pkfield from myTable order by pkfield DESC)>
>Nope. This does not work either.
Check this thread How does TOP work? Thread #1362672