DISABLE/ENABLE TRIGGER bug

• 
  Hi Klaus,
  
  Are you saying that you filled in the ON clause, then went back and filled in the trigger name?
  
  I'll get a private build out to you with the table attached to the trigger shown in the suggestions window when I've made the change.
  
  Best regards,
  
  David

  David Priddle October 17, 2014 09:00

  - 0 +
• 
  Hi David,
  
  no, the error occurs when after typing the owner name of the trigger, then choosing the trigger from the suggestion list. After that SQL Prompt auto-completes the ON clause and the table name (forgetting the owner of the table).

  kondrich October 20, 2014 01:39

  - 0 +
• 
  Ah fantastic,
  
  I can reproduce this now! Thanks for your patience!
  
  Best regards,
  
  David

  David Priddle October 20, 2014 03:01

  - 0 +
• 
  Hi Klaus,
  
  I've got a private build here that should fix the issue for you. It also should show the table the trigger refers to in the suggestions list.
  
  Let me know if you encounter any problems.
  
  Best regards,
  
  David

  David Priddle October 21, 2014 08:48

  - 0 +
• 
  Hi David,
  
  thank you for fixing this issue. I confirm that the generated script now also contains the owner name of the table, even if the trigger owner was manually typed.
  Including the table name in the suggestion list is very useful, too. Would it be possible to show the owner/schema of the table, too?
  Currently in suggestion list:

  Trigger_Name       Table_Name
  

  Suggested suggesion:

  Trigger_Name       Schema.Table_Name
  

  kondrich October 21, 2014 09:04

  - 0 +
• 
  Hi Klaus,
  
  Would this only be applied to triggers? Or other object types that show up in suggestions?
  
  Best regards,
  
  David

  David Priddle October 21, 2014 09:19

  - 0 +
• 
  Hi David,
  
  displaying the owner name seems to be a little inconsistent for now: Schema/Owner is displayed for tables, but not for views, procedures, functions, triggers and synonyms.
  We would find it useful to have the schema always in the suggestion box.

  kondrich October 21, 2014 10:10

  - 0 +
• 
  Hi Klaus,
  
  The owner is set to show only if there is an owner clash between two objects with the same name.
  
  You can get the schema / owner to show for each item if you click on the "Show schema names" button:
  
  
  
  Please let me know if this helps at all.
  
  Best regards,
  
  David

  David Priddle October 21, 2014 10:27

  - 0 +
• 
  Hi David,
  
  oh, I did not know this button. It's really useful. Thanks for the hint. It does exactly what I was looking for (however not for triggers).

  kondrich October 21, 2014 10:31

  - 0 +
• 
  Hi Klaus,
  
  Don't worry, it's not the most obvious!
  
  You're quite right, it doesn't register for triggers. I'll put in a fix for that now.
  
  Thanks,
  
  David

  David Priddle October 21, 2014 11:07

  - 0 +

Add comment

Please sign in to leave a comment.