>>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!
Tom Gahagan
Alliance
Computer Solutions
"Music, like sex, is much too important to be left to professionals."
Robert Shaw