I have a question regarding triggers. Lets say I have 2 Tables set up like:
[tt]
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)
[/tt]
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>
[tt]
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)
[/tt]
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>