Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set Filter and GO Bottom
Message
From
06/05/2004 15:13:55
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
06/05/2004 14:45:46
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00901656
Message ID:
00901713
Views:
14
>I have try this solution, but:
>
>a) when a index is active, VFP LOCATE use a scan/seek method,
>and this is not the much best one than GO BOTTOM.

Only a problem if the index is in different sequence from the table.

>
>b) use a descending index have the
>- a) limit
>- i must build a index for do only this simple task
>
>
>INDEX ON .T. TAG descTag DESCENDING
>
>
Is index smaller using .T. or "A"? Same number of keystrokes.

>
>Use SET ORDER DESCENDING with other tags.
>

>
>when a index is active ( with a) limit ) :
>
>SET ORDER TO TAGNO() DESCENDING
>LOCATE
>SET ORDER TO TAGNO()
>
>can resolve the problem
>
>Question:
>VFP support this for set the RECNO() order:
>
>SET ORDER TO 0
>
>Why it not support this
>( no error is fired, but recno() ascending is applied )?
>
>SET ORDER TO 0 DESCENDING
>
>
>Thanks Mike

No, that's why I made the INDEX ON "A" TAG myATag.
Previous
Reply
Map
View

Click here to load this message in the networking platform