>I made the typing error here, in my message. There is no error in the SP because I have code before and after the APPEND BLANK and those lines work.
>
>I just did another test where I tried to REPLACE a value in a field with some dummy value and then get the value in the field immediately after the REPLACE. And the value in the field is still old value. As if something prevents the fields to be updated and records to be added to my application tables. Note that I test the code by creating "dummy" test.dbf table and inserting records into this table in certain places of my code. And the dummy test.dbf gets all the new records and all values.
>
Did you test your SP from VFP? (Make a copy of the database if you don't want to insert records into your main database).
In the command window try
SET EXCLUSIVE ON
then try your SP again. Does it still work? (Open your table in another version of VFP).
May be replace command is failing.
If it's not broken, fix it until it is.
My Blog