Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Re-order records with MOVE UP / MOVE DOWN
Message
From
14/11/2000 22:19:49
 
 
To
13/11/2000 23:08:06
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00441438
Message ID:
00441960
Views:
22
Yeah, that's the most brute way I could think of.

Please share your your psuedo-code off
the top of your head for the MoveUp.click() method....




>>When I am adding records to my grid, sometimes I want to change the order from the way they were entered (i.e. line items on a purchase order).
>
>If you want the natural record number to change, youc ould probably use INSERT (non-SQL) but that requires exclusive use of table and is not multiuser.
>
>You could also try using a list box with the Mover Bars set on.
>
>To do it with a grid, I suggest creating an order field, and then the move up, move down, just swaps the value of the field with the record above it (if you want to move up) or the record below it (if you want to move down).
>
>Just SET ORDER TO that field and refersh. Walla.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform