>Hi all,
>SQL INSERT INTO adds a record to the end of a table. How can I
>insert a record in between records in a table ?
>Thanks.
>
>Kam.
Kam,
With indexes available it is never necessary to insert a record in a specific location. Reliance of physical location of records is a poor relational design anyway as record nmbers can and do change over time.
The old xBase INSERT command did what you are looking for but it was equivalent to SET SLOW ON. This was because it copied the entire file up to the insertion point, then added the enw record, then copied the rest of the file. After that is erased the original and renamed the new file to the old name, it then recreated all of the indexes for the newly named file.