>unfortunately it's not working, it inserts as the last record, while I need it inserts as the first record.
>
>regards,
>
>Jerry
>
>

It works, but ( of course ) it has a lot of restrictions:
- none open index
- no buffering
- no RI
- exclusive access
....

example:

CREATE CURSOR BYBY (AA I)
APPEND BLANK
REPLACE AA WITH RECNO()
APPEND BLANK
REPLACE AA WITH RECNO()
GO 1
INSERT BEFORE BLANK
? AA,RECNO()
BROWSE NORMAL

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