>>>Now, I have another problem, when two users same the data to the table at
>the same time, sometime one of it table is not updated.
>>>Is there any different of the below two coding? Because when I used
>sample (1) to update my data which is enter in grid, the data is gone if
>the program perform (=tablerevert(.t.)) function.
>>>
>>>(1)=====================
>>>Begin Trans
>>> (update table)
>>> =tableupdate(.t.)
>>>End Trans
>>>
>>>(2)=====================
>>>Begin Trans
>>> (Update table)
>>>Endd Trans
>>>=tableupdate(.t.)
>>>*=======================
>
>They are not the same.
>
>If something happens in #1 before the END Trans,
>you can ROLLBACK the transaction at the dot prompt.
>
>If something happens in #1 during the =tableupdate(.t.),
>you will NOT be able to ROLLBACK the transaction at the
>dot prompt.

Are you referring to dot prompt, or Command Window? Sorry, what I know with Dot prompt is for DBASE. No malice here...