>>I WAS LOOKING TO SEE IF THE INSERT <> APPEND AS I wanted to insert a record into the midst of a table rather than at the end. The help file doesn't indicate this, am I wrong about this. Thank you.
>
>Timothy,
>
>The OLD xBase Insert command will do what you are describing (not the INSERT INTO ... command).
>
>Now for the bad news, the xBase command does this by;
>
>

>1. Copying the entire table to a new table up to the position at which you have inserted the new record
>2. Placing the new record in
>3. Copying the rest of the old tables records to the new file
>4. Erasing the old table
>5. Renaming the new table to teh old name
>6. Recreating any indexes that may have existed
>

>
The FPW 2.6 help file says

Inserts a new record into the current table/.DBF immediately after the current record and displays the new record for editing.

and warns about the issues you mention. What it doesn't say is that This will work only if there is no index tag.

When I tried it, the new record was always placed at the end of the table if the table was indexed.