Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement