I am having a wierd issue with a Cursor Adapter

If i insert one record with an append blank and then replace the values with REPLACE, works well, however in some particular part of the code i perform a APPEND FROM TABLE.DBF

then, i need to bring a value from another table and update one particular field so I perform a Scan EndScan

when the cycle is over, I browse the CA an the value is there, but when i see the sql table, ain't it.

i even run atableupdate and nothing

any ideas??