Database Trigger mysql

Discussions about database modeling product Cameo Data Modeler functionalities

Moderator: Moderators

Database Trigger mysql

Postby emetis » Tue Mar 30, 2010 3:51 am

Hello,

I want to add a trigger to my database table. Therefore i created an operation with stereotype trigger.
Then i selected tags of my operation and then added a dummy value for the tag "triggered action".
Unfortunately the generated sql does not contain anything about my trigger.

Can anyone tell my what is going wrong?

...sorry if this is the wrong category for my topic but i had no idea where to post it otherwise

Regards
Harri E.
emetis
Forum Newbie
Forum Newbie
 
Posts: 4
Posts Rating:0
Joined: Thu Mar 11, 2010 3:29 am

Re: Database Trigger mysql

Postby saulius_p » Tue Mar 30, 2010 9:03 am

Hello,

Your are creating DB trigger correctly. The problem is that our generator for MySQL (version 4.x), does not support trigger definition. Triggers are supported by other DDL dialects. We are considering to upgrade MySQL support up to latest version, but schedule is not set yet.

Sorry for the inconveniences you are experiencing. If you have more questions or problems feel free to contact us.

Best regards,
Best regards,
Saulius Pavalkis
User avatar
saulius_p
No Magic
No Magic
 
Posts: 259
Posts Rating:10
Joined: Fri Dec 04, 2009 5:37 am
Full name: Saulius Pavalkis


Return to Cameo Data Modeler

Who is online

Users browsing this forum: No registered users and 0 guests

cron