Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with TableUpdate and Scan
Message
From
22/03/2001 00:15:20
 
 
To
22/03/2001 00:03:42
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00486829
Message ID:
00487514
Views:
11
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform