Try INSERT INTO instead of append blank. Also, check the buffering status and transaction status.
>Dear friends,
>
>I was trying to update one of my table in my application. When I use a "APPEND BLANK" and "REPLACE" command after the record updation it is vanishing from the table. But, if I open the table in "BROWSE" and insert a record using "Ctrl+Y" then it is stored in the table.
>
>After using this "BROWSE" then I am able to give "APPEND BLANK" and "REPLACE", this error is coming occassionally, I don't know how to simulate this bug.
>
>Kindly help me to solve this problem.
>
>P S Logamoorthy