You don't happen to use a view as the record source? I have seen similar symptoms only in views, when the update criteria aren't set correctly.
Hilmar.
>I have a table in a private datasession with buffermode = 5.
>The current record in the table is edited through form controls and then a tableupdate(1,.F.,"MYTABLE") is performed which returns .T. There is a transaction around this and some other code and this transaction always ends and a flush is done straight afterwards.
>
>If I put a browse statement after the transaction I see the table with the changes. If I then close and reopen the table the changes are still there.
>
>If I don't put a browse statement in then the data isn't in the table when I close and reopen it. (even before I close it - a wait window reveals old values in fields)
>
>What does this mean ?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
