>>>>Could you at least Browse your table and see changes without re-opening? If it's the case then you should find a way to show them on screen immediately.
>>> Yes, i saw it, i can see the data on the table using browse, but even closing the form and opening again it didn't show anything. Here some of the code:
>>>
>>>*orders.dbf ->opened by dataenvironment
>>>if param.cstat=1 &&save statistics
>>>*check statistics file
>>> cfi=alltrim(param.ordstatfile)
>>> if file(cfi)
>>> use &cfi in 0 alias est_orders
>>> endif
>>>endif
>>>cursorsetprop("Buffering",5,"orders")
>>>sele orders
>>>replace dmodi with date(), usmod with suser(), ....
>>>if used("est_orders") &&apply statistics
>>> cursorsetprop("buffering",5,"est_orders")
>>> insert into statistics (nord,date,....) values(num_ord,date(),....)
>>>endif
>>>begin transaction
>>>if tableupdate(1,.T.,"orders")
>>> end transaction
>>> if used("est_orders")
>>> begin transaction
>>> if tableupdate(1,.t.,"est_orders")
>>> end transaction
>>> else
>>> rollback
>>> =tablerevert(.T.,"est_orders")
>>> messageb("Statistics can't be saved",16,"Error")
>>> endif
>>> endif
>>>else
>>> rollback
>>> =tablerevert(.T.,"orders")
>>> messageb("Orders can't be saved",16,"Error")
>>>endif
>>>
>>>What do you use in the form to show the data?
>>
>>>a GRID because this orders table is detail for other table, but i'm just changing exactly the detail. The header is still showing well.
>
>>Can you set buffering 5 once in Load of the form? Why do you need to switch the buffering?
>
>>Also add grid.Refresh() after you've saved the data.
>
>Trust me that if i close the form and reopen it again it must be refreshed right?, but it didn't. the form already has refresh for view and even a thisform.refresh when finish. And talking about cursorsetprop, i always open with cursorsetprop in 1 just change it when saving data to 5 then it will be restablished to 1, it helps to save time when opening large tables.

You may add FLUSH() command to force the changes saved.