Triggers
Triggers
(OP)
I have a question regarding triggers. Lets say I have 2 Tables set up like:
TableA
Field1 Num(25)
Field2 Char(255)
Field3 Char(255)
Field4 Num(25)
Field5 Char(255)
Field6 Char(255)
TableB
Field1 Num(25)
Field2 Char(25)
Field3 Char(255)
And a trigger, that would copy the first 3 fields of Table A to Table B on an insert. If I get a value from TableA Field2 which is longer than 25 Char, what will happen.
Somone suggested to me that if this trigger fails, then the insert on the first table will also fail. Does anyone have any impot on this?
TableA
Field1 Num(25)
Field2 Char(255)
Field3 Char(255)
Field4 Num(25)
Field5 Char(255)
Field6 Char(255)
TableB
Field1 Num(25)
Field2 Char(25)
Field3 Char(255)
And a trigger, that would copy the first 3 fields of Table A to Table B on an insert. If I get a value from TableA Field2 which is longer than 25 Char, what will happen.
Somone suggested to me that if this trigger fails, then the insert on the first table will also fail. Does anyone have any impot on this?
Craig, mailto:sander@cogeco.ca
Bow Before me for I am ROOT
<Beer>Happiness</Beer>
RE: Triggers
First, you're trigger won't fail because an insert into tableb doesn't have a column long enough. The data in tableb will just be truncated (At least that's the way it is on my solaris 7, Online 7.31UC2).
Second, if a trigger does fail (i.e. constraint violation, table lock, etc) does the insert on table a fail? Yes, at least it does if transactions are turned on.
Regards,
Ed
Schaefer