If you have a primary key field, and the table is not buffered, and the table already has a blank record, APPEND BLANK will generate an error that uniqueness of the primary key has been violated and the append will fail. Normally in this case, an error is generated, the append blank would be reverted and the record pointer would be left at EOF(), so that does not explain why the first record was replaced. Do you get any error message at all?

Another thought, is it possible that you have a comment ending with a semicolon on the line just above the append blank. The semicolon is a line continuation character that would make the Append blank line a part of the comment.

HTH


>Hi,
>
>I am having trouble with the Append Blank - Replace commands.
>
>My code looks like this:
>
>Select MyTable
>Append Blank
>Replace............
>
>It seems like the 'Append Blank' is not doing anything.
>I had 20 records to start with. After I issued the above commands, I still had 20 records and the first record was replaced by the values defined in the last REPLACE statement that I issued.
>
>Any help will be greatly appreciated.
>
>Thank you.
>
>Ria