Tim

Any chance of being able to detect the field type in triggers. It will make re-introducing RTRIM for VARCHARs easier.

Roy Lambert

Roy,

<< Any chance of being able to detect the field type in triggers. It will
make re-introducing RTRIM for VARCHARs easier. >>

Access to the NEWROW columns is hard-coded like a variable, therefore you
need to know which columns are which prior to creating the trigger anyways.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


OK so is there any easier way than hard coding every varchar field name in the database?

Roy Lambert

Tim


And a slightly different question. I want to ensure that VARCHAR fields are NULL not empty string and I want to remove trailing spaces. Is a trigger the best place or is there a better option, if so what?

Roy Lambert

Roy,

<< OK so is there any easier way than hard coding every varchar field name
in the database? >>

No, because you have to hard-code the NEWROW reference.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< And a slightly different question. I want to ensure that VARCHAR fields
are NULL not empty string and I want to remove trailing spaces. Is a trigger
the best place or is there a better option, if so what? >>

No, triggers are where you should put that type of code.

--
Tim Young
Elevate Software
www.elevatesoft.com