Tim


I'm just using the grid in EDBMan. I'm going to delete the trigger (again) and try Ole's code

Roy Lambert

Tim


Tried it with Ole's trigger, dropped the sql into EDBMan and created the trigger that way and it worked.

Than gives me a mechanism to use until you come up with a decent situation. It means two triggers for each table (insert and update) and making sure I keep the field list up to date.

Two questions

1. I doubt it will affect me but is there a sequence in which triggers fire?

2. Is there a way within the trigger to loop round, get all the fields, check their type and trim if VARCHAR? I'm guessing that it should be possible but with my current success rate of writing a trigger I'd like to know first. A supplementary question is what is that likely to do to performance?

Roy Lambert

ps Whereabouts on your priority list is allowing us to edit triggers etc?

Roy,

<< I'm just using the grid in EDBMan. >>

Do you mean the right-hand list view ?   There isn't really a "grid" for
triggers.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< 1. I doubt it will affect me but is there a sequence in which triggers
fire? >>

The fire in their defined order.

<< 2. Is there a way within the trigger to loop round, get all the fields,
check their type and trim if VARCHAR? I'm guessing that it should be
possible but with my current success rate of writing a trigger I'd like to
know first. A supplementary question is what is that likely to do to
performance? >>

There isn't currently a way in any EDB routine to dynamically reference a
column in terms of a SET statement.  It is something that I've had on the
list for a while now, so I'll see what I can do.

<< ps Whereabouts on your priority list is allowing us to edit triggers etc?
>>

It's the same as with views, procedures, and functions so it will probably
make it into a 1.02 or 1.03 release.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


OK, in the grid that is displayed when you open a table.


Roy Lambert

Roy,

<< OK, in the grid that is displayed when you open a table. >>

Never mind my question.  When I went back and looked, I realized that I was
asking a question for your other trigger thread, not this one.

--
Tim Young
Elevate Software
www.elevatesoft.com