How can we help you today? How can we help you today?

Trigger and Table script order

We added a column to an existing table, and modified the existing trigger on the table to reference the new column. When generating the sql diff script, it put the triggers first, then the alter table statement. The trigger script complains that the column does not exist. Is this a bug? I didnt see any options to control this behavior, we are using 3.0.0.130.
dennis
0

Comments

3 comments

Sort by
  • Brian Donahue
    Hello Dennis,

    Can you please upgrade to the latest version and see if the problem still occurs? For you, this will be a free upgrade that you can get from Help->Check for Updates or from our website.
    Brian Donahue
    0
  • dennis
    Brian, I tried that and it said "The Update Service did not find updates for your application".
    dennis
    0
  • Brian Donahue
    Hi Dennis,

    We are currently on version 3.2.0.5. How about downloading the latest version from ftp.red-gate.com?
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.