creating oracle triggers

[dmaxwell]

Hi All,

I've been trying to generate triggers (pre insert and pre update) along with my tables when I generate ddl. The problem that I've been running into is that what is being generated is syntacially incorrect. EA seems to be generating the "on tablename" before any "before insert" statement. I've not found a way to tell EA this is a "before insert" trigger.

So I developed a work around...when I name the trigger I name it "triggername before insert" or "triggername before update". When I do this, EA generates ddl code that works.

So my question is...is this the way I should be doing this? Am I missing or misusing a property of the operation?

Thanks

Dana

[thomaskilian]

DDL generation is not configurable except when using Tags. So you either go for your own code generation (you have to search the appropriate threads here) or you ask Sparx for an enhancement. There might be another solution, though.