Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Anywhere but there...
Message
From
03/03/2008 09:57:09
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
03/03/2008 09:20:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01297718
Message ID:
01298141
Views:
29
Hi Luke

>The objective here is allow users to insert line items if they've forgotten something rather than having to delete n-number of items, add what they needed and then re-enter what was removed. I mean it can be done; SCATTER the last line of contents into MEMVAR, GO BOTTOM, GATHER it into the added record, get what was the second last line of contents and so on. The other thought I had was to re-shuffle to PK's, or create an array and re-shuffle that, but these all have their down sides so I'm looking for other ideas.
>Thanks.

There is another quick solution. Add a numeric field with some number of decimal places. Index the records on this numeric field. To insert a record between 4 and 5, give it the value 4.5. To insert between 4 and 4.5 give it 4.25, etc.
Previous
Reply
Map
View

Click here to load this message in the networking platform