--0016367b6c30caea42048da19a18
Content-Type: text/plain; charset=ISO-8859-1
Hi,
I think that I have a conceptual problem and I hope anyone could help me.
If I write a trigger AFTER INSERT and I have one error in this trigger, the
record (that I think was already inserted) is not inserted.
Example:
INSERT INTO tableX <record1>
trigger sumRecords AFTER INSERT under tableX to accumulate the records
inserted by hour
if there is an error in the commands executed for this record, <record1> is
not in the tableX
If this occurs in a trigger BEFORE INSERT, I can understand, but, if it is
AFTER INSERT, I believe that the record is already inserted.
What is wrong on it?
Thanks in advance
Josi Perez
--0016367b6c30caea42048da19a18
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Hi,<br><br>I think that I have a conceptual problem and I hope anyone could=
help me.<br><br>If I write a trigger AFTER INSERT and I have one error in =
this trigger, the record (that I think was already inserted) is not inserte=
d.<br>
Example:<br><br>INSERT INTO tableX <record1><br>trigger sumRecords AF=
TER INSERT under tableX to accumulate the records inserted by hour<br>if th=
ere is an error in the commands executed for this record, <record1> i=
s not in the tableX<br>
<br>If this occurs in a trigger BEFORE INSERT, I can understand, but, if it=
is AFTER INSERT, I believe that the record is already inserted.<br>What is=
wrong on it?<br><br>Thanks in advance<br>Josi Perez<br><div style=3D"visib=
ility: hidden; display: inline;" id=3D"avg_ls_inline_popup">
</div><style type=3D"text/css">#avg_ls_inline_popup { position:absolute; =
z-index:9999; padding: 0px 0px; margin-left: 0px; margin-top: 0px; widt=
h: 240px; overflow: hidden; word-wrap: break-word; color: black; font-s=
ize: 10px; text-align: left; line-height: 13px;}</style>
--0016367b6c30caea42048da19a18--
