>>I use the add trigger for assigning unique values from my
>> unique value table. Works great.
>
>How do you do this when triggers will not allow you
>change any data in >the table that caused the
>trigger to fire?
Exactly as Vladimir explained. I'm just providing variables
before the data is saved by the trigger. The information
that goes into the variables are from other tables,
user input, etc. Just return to the alias() where the
trigger is from.
I have read in a few places (as your question implies)
NEVER NEVER NEVER manipulate the current table
in a trigger.
Deleting is the same thing. No deleting is done in the
current table, just other tables. Just return to the
alias() where the trigger is from.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement