Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Erin,
From Hacker's Guide (Granor & Roche):
INSERT adds records to the current table at the current record pointer position. INSERT is almost always a bad idea. This command is part of FoxPro's Xbase legacy and generally leads to bad code. In all our experience, we've only found one situation where using INSERT was a good idea—more on that below.
Don't confuse this INSERT command with the SQL INSERT command, which is very useful.
Used by itself, INSERT is much like APPEND by itself, but requires exclusive access
If using an index (like the others have mentioned) does not do what you want, why do you need to have the new record in the middle? Are you perhaps using RECNO() as the PK?
>I am trying to "append" a new record into a table...however, I would like it to be inserted into the middle of the table instead of the end. Is this at all possible? TIA :)
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
