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.