Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Order table Ascending Descending in Data Environment
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00382418
Message ID:
00382694
Views:
18
This will not work because the table is part of a data environment. Changing the sort order is done by changing the order property on the table in teh data environment.


>You can use the ASCENDING or DESCENDING keyword with any tag, without having to designate one or the other when you build the tag. The DESCENDING() function will tell you which way the current order is going. So, a method to do this would be as follows:
>
>lcCurOrder = ORDER()
>llDescend  = DESCENDING()
>IF llDescend
>   SET ORDER TO (lcCurOrder) ASCENDING
>ELSE
>   SET ORDER TO (lcCurOrder) DESCENDING
>ENDIF
>
>>I have a list of data that the client wants to be able to click on a control and have the data displayed in ascending order, click the control again and it is in descending order. Using the data environment, without creating an index each way, is there a way?
Fred Lauckner

You know, it works on my computer. I don't know what your problem is.

.Net aint so bad.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform