Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with TableUpdate and Scan
Message
De
22/03/2001 00:15:20
 
 
À
22/03/2001 00:03:42
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00486829
Message ID:
00487514
Vues:
10
>Ed,
>
>OK, but the scenario in my form looks like that,
>
>
>1st
>* For the two tables (artigos/artigosarm*
>begin transaction
> ...
> ...
>endtransaction
>*my geral method (all other tables)*
>2nd
>begin transantion
> ...
> ...
>endtransaction
>
>
>If the second fails is possible to revert the first.

Yes; you can nest transactions:

* For the two tables (artigos/artigosarm*
begin transaction
...
...
IF Something Fails
ROLLBACK
ELSE
*my geral method (all other tables)*

begin transaction
...
...
IF Something else Fails
ROLLBACK
ROLLBACK
ELSE
end transaction
end transaction
ENDIF
ENDIF

Transactions can nest up to 5 levels
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform