I actually went back to FPW 2.6 and read the help for it. Any defined indexes (active or not) will cause the INSERT to not insert into the middle of the table.

Boy, this is a pretty long thread about a command we shouldn't be using anyway :)

>>>Also note that INSERT won't insert a record at the current record pointer if there are any indexes on the table.
>
>This is really strange. I thought I remembered this command so I did an index and search of MSDN and it did not come up so I thought they had done away with it! After I saw your posts I went back and the only place I could find it was in the A-Z language reference and it only gave one line of comment. REally strange.
>
>Anyway, I went to VFP and tried it and I could not get it to insert at the recrod pointer with any type of table. All records were inserted at the end.
>Strange!