General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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 :)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only