[Squirrel-sql-commits] sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/tab TriggerDetailsTab.java, 1.6, 1.7

[Rob M. <man...@us...>]

Update of /cvsroot/squirrel-sql/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/tab
In directory sc8-pr-cvs8.sourceforge.net:/tmp/cvs-serv17774/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/tab

Modified Files:
	TriggerDetailsTab.java 
Log Message:
Added validity (VALID|INVALID) to trigger details tab, to show whether or not a trigger is valid or invalid.

Index: TriggerDetailsTab.java
===================================================================
RCS file: /cvsroot/squirrel-sql/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/tab/TriggerDetailsTab.java,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** TriggerDetailsTab.java	28 Apr 2007 11:50:38 -0000	1.6
--- TriggerDetailsTab.java	21 Jan 2008 00:16:39 -0000	1.7
***************
*** 51,59 ****
  	/** SQL that retrieves the data. */
  	private static String SQL =
! 		"select owner, trigger_name, trigger_type, triggering_event, table_owner," +
! 		" base_object_type, table_name, column_name," +
! 		" referencing_names, when_clause, status, description, action_type" +
! 		" from sys.all_triggers where owner = ?" +
! 		" and trigger_name = ?";
  
  	public TriggerDetailsTab()
--- 51,62 ----
  	/** SQL that retrieves the data. */
  	private static String SQL =
! 		"select t.owner, t.trigger_name, t.trigger_type, t.triggering_event, t.table_owner, " +
! 		" t.base_object_type, t.table_name, t.column_name, " +
! 		" t.referencing_names, t.when_clause, t.status, t.description, t.action_type, o.status as validity " +
! 		" from sys.all_triggers t, user_objects o " +
! 		" where t.trigger_name = o.OBJECT_NAME " +
! 		" and t.owner = ? " +
! 		" and t.trigger_name = ? ";
! 
  
  	public TriggerDetailsTab()