[Tora-cvs] SF.net SVN: tora:[3240] trunk/tora/src/tobrowsertablewidget.cpp

[<su...@us...>]

Revision: 3240
          http://tora.svn.sourceforge.net/tora/?rev=3240&view=rev
Author:   subik
Date:     2009-08-16 17:37:19 +0000 (Sun, 16 Aug 2009)

Log Message:
-----------
fixed #2815244 Repeating references in Schema Browser

Modified Paths:
--------------
    trunk/tora/src/tobrowsertablewidget.cpp

Modified: trunk/tora/src/tobrowsertablewidget.cpp
===================================================================
--- trunk/tora/src/tobrowsertablewidget.cpp	2009-08-16 17:17:23 UTC (rev 3239)
+++ trunk/tora/src/tobrowsertablewidget.cpp	2009-08-16 17:37:19 UTC (rev 3240)
@@ -216,11 +216,13 @@
     "       sys.all_cons_columns r,\n"
     "       sys.all_cons_columns c\n"
     " WHERE a.constraint_type = 'R'\n"
-    "   AND a.r_constraint_name IN ( SELECT b.constraint_name\n"
-    "                                  FROM sys.all_constraints b\n"
-    "                                 WHERE b.OWNER = :owner<char[101]>\n"
-    "                                   AND b.TABLE_NAME = :tab<char[101]> )\n"
+    "   AND (a.r_owner, a.r_constraint_name) IN ( SELECT b.owner, b.constraint_name\n"
+    "                                              FROM sys.all_constraints b\n"
+    "                                             WHERE b.OWNER = :owner<char[101]>\n"
+    "                                               AND b.TABLE_NAME = :tab<char[101]> )\n"
+    "   AND a.r_owner = r.owner\n"
     "   AND a.r_constraint_name = r.constraint_name\n"
+    "   AND a.owner = c.owner\n"
     "   AND a.constraint_name = c.constraint_name\n"
     " UNION SELECT owner,\n"
     "       name,\n"


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.