Well, I stand corrected. :) I started with VFP, and never even noticed there was anything besides INSERT INTO. Now I know it exists, but it doesn't sound worth using. LOL!

Michelle


>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
>

>
>You could get your record where you want it by using an inderx and simply copying the table with teh index in control. This approach would be quite a bit faster than the old xBase Insert command ever was.
>
>Even in the FoxBase and dBaseII days not many folks ever actually used the xBase Insert command because it was abysmally slow and there were faster and better ways to control the order of records.