Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Datasessions and Transactions
Message
 
To
27/07/1996 10:27:54
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00004646
Message ID:
00004670
Views:
49
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform