Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Technique to benefit of invisible character
Message
From
14/04/2002 02:43:05
 
 
To
14/04/2002 02:07:00
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00641634
Message ID:
00644791
Views:
15
>Just some ideas:
>- Set a flag field for sorting, and on that record you like at top, set a number or a char or simply a logical field (if all are .T. and the top record .F. this can be sorted ascending or descendig like you want)
>- Use a char Like . or _ or whatever you want, and at the report field that show the record, put a substr() function.

We didn't want to change something in the table structure. To fit that need, we ended up to put a dot in front. At edit time, we show that field instead of a data entry field as it shouldn't be changed. So, once a record created with that requirement, the value of that field will remain as is. So, it'll always appear on top of the order.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform