Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is Index Tag in Descending Order?
Message
From
28/06/2001 11:23:41
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00524342
Message ID:
00524729
Views:
14
>I'm writing a utility that will loop through every DBF in a specific directory, open them, loop through the tags in each one, and spit out that info (DBF(), TAG(), and KEY()) into another DBF. My problem is, I also need to know if it's in ASCENDING or DESCENDING order.
>
>Is there a command (or something) that will return whether a specific Index Tag in in Descending or Ascending order?
>
>Thanks!

Just be forewarned that DESCENDING() tells you about the current order of the tag, not the definition order. If the table is set to the order in more than work area, it has to be either ascending or descending in all of them, which means you can't even count on this working in a USE AGAIN scenario, unless you make sure the table is closed before you start.

Personally, I create all indexes in ascending order and flip them when needed.

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform