Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multi-user Updating Problem
Message
 
À
17/06/1998 22:20:47
Thian Li Choo
Malitnet Group of Companies
Kuching, Malaisie
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00109357
Message ID:
00109394
Vues:
35
>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."
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform