Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trigger Invocation Cancel All Work
Message
De
22/10/2001 16:08:46
Keith Payne
Technical Marketing Solutions
Floride, États-Unis
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00571639
Message ID:
00571842
Vues:
30
That's a 4-star answer!

>Hi!
>
>Does you trigger use ROLLBACK? If yes - here is an answer. Even when you have several BEGIN Transaction, Rollback cause reverting all changes and cancelling of ALL transactions (unlike in VFP). END transaction does decrease transaction level counter for the most recent transaction only, and does not update at all, indeed, until the last transaction is ended.
>
>HTH.
>
>>Hello,
>>
>>I need some help about this:
>>
>>I've a trigger in a table that writes some data in another table of another database, but the main problem it's when the local application send a group of updates to the triggered table all the process betewwen this instructions
>>
>> set implicit transaction on
>>
>> insert into table1 (...)
>> update table 2 (...) /* This it's the triggered table */
>>
>> 'IF @@TRANCOUNT > 0 COMMIT TRAN'
>> set implicit transaction off
>>
>>simple disapear! It's like the transactions were not comitted...
>>
>>Ideas?!
>>
>>Thanks,
>>Manuel Almeida
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform