Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving one record before another?
Message
 
To
10/04/1998 22:05:14
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00091247
Message ID:
00091250
Views:
18
>How can I change the order of records in a non-indexed table so as to move one record before another.
>
>Here's the scenario: When entering step-by-step instructions on a Shop Order (to tell employees the order in which a job should be done), sometimes, you want to go back and add a new step between two existing steps, or after a certain step, or before a certain step. The records are collected in a grid, where a command button on the form does an append, then passes focus to the new record in the grid. How can I allow for re-ordering, without having a field in the table that stores the sequence number?
>
>I need a mover or something.

Matt, if you need just insert the records, you could use INSERT BLANK [BEFORE],
but your table must be opened EXCLUSIVE, which may not be convenient. What is the reason not to use indexing?

Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform