>I have a table with lots of record, I want to insert one record at the top of it (as recno #1), the old fashion way is to copy all the records to temporer table, zap it, insert the record, re-append from the temporer table.
>
>but I think it should be another easier way.
>
>please advise
>
>thanks for the help
>
>regards,
>
>Jerry

You can do this with the old INSERT xBase command,
but this can have sense in very specific cases with a little table:

SELECT myTable
GO 1
* next build a new table with 1 empty record and append the active wa
INSERT BEFORE BLANK
REPLACE .....