unfortunately it's not working, it inserts as the last record, while I need it inserts as the first record.
regards,
Jerry
>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 .....
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only