Subject | "beginners" question |
---|---|
Author | Olaf Kluge |
Post date | 2011-06-15T09:25:36Z |
Thank you in advance for your patience.
I want to dive deeper into the basics of firebird. It does not look like so,
but I have created a lot in firebird ;o)
Well, I have a table with an update-trigger. At a specified value I can set
"new.value = somevalue" okay.
If I must change some data for example: (if all records have the value of
XX, condition new.valueofsomefiled), then:
Update sametable set statusfield = XX where condition = XX.
How protects firebird itself for running an endless loop? (the update
trigger updates the table and normally the update of the update runs a
update .
Thank you for your help.
Best regards.
Olaf
[Non-text portions of this message have been removed]
I want to dive deeper into the basics of firebird. It does not look like so,
but I have created a lot in firebird ;o)
Well, I have a table with an update-trigger. At a specified value I can set
"new.value = somevalue" okay.
If I must change some data for example: (if all records have the value of
XX, condition new.valueofsomefiled), then:
Update sametable set statusfield = XX where condition = XX.
How protects firebird itself for running an endless loop? (the update
trigger updates the table and normally the update of the update runs a
update .
Thank you for your help.
Best regards.
Olaf
[Non-text portions of this message have been removed]