>The second question is: When you perform an insert sql, let's say that after it you have some code that need to change one of the record field. After the insert, will the inserted record be currently pointed? If it is the case, it means that you can just perform a replace on it I guess.

Yes. Yup. Confirmed. Absolutely. Exactly. Correctamundo.

>ALso: In my application, I did put the forms as optimistic buffered mode. When I do a change, I perform a tableupdate(2,.T.). With an insert, do I still have to perform the tableupdate to write the change in the database or is it done directly ?

You must do the tableupdate.