>The solution given by Fred Lauckner on 20/05/98 is very helpful, it's solved my problem and I would like to thank him.
>
>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.)
>*=======================
>
>Thank in advance.
>
I would rather suggest the following code:
DO CHANGES HERE (REPLACE, UPDATE, DELETE, INSERT)
BEGIN TRANSACTION
IF !TABLEUPDATE(.T.,'tablename')
ROLLBACK
ELSE
END TRANSACTION
ENDIF
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."