Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi-user Updating Problem
Message
 
 
To
17/06/1998 22:20:47
Thian Li Choo
Malitnet Group of Companies
Kuching, Malaysia
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00109357
Message ID:
00109394
Views:
34
>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."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform