Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Datasessions and Transactions
Message
 
À
27/07/1996 10:27:54
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00004646
Message ID:
00004670
Vues:
53
Hi Doug,

>After taking another look, I basically have something like:
>
> BEGIN TRANSACTION

!Warning: it's not recomended that you begin a transaction
before a "large" sequence of instructions, like the cycle
you have. I would say that you have to move the BEGIN
TRANSACTION before TABLEUPDATEing each cursor.

> For each cursor

** begin your transaction here ***
> IF NOT (TABLEUPDATE(.T., .T., cursor))
> lTransRolledBack = .T.
> ROLLBACK
> Display message explaining problem
** ELSE: then u will have to end each successful transaction.

> ENDIF
> Endfor
>

On the other hand, i don't like the code generated by the
RI shiped with VFP, and AFAIK in version 3.0 it was not
working OK with composite keys, ie. when a key has more
than 1 field. I preffer to use SQL to handle myself RI
code.

HTH,

J. Luis
J. Luis Santiago Rodríguez.• CADIS • E-mail: jlsantiago@iserve.net.mx• Ciudad de México.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform