[Tora-cvs] SF.net SVN: tora:[4151] trunk/tora/src/tobrowserdirectorieswidget.cpp

[<ibr...@us...>]

Revision: 4151
          http://tora.svn.sourceforge.net/tora/?rev=4151&view=rev
Author:   ibre5041
Date:     2011-11-22 12:06:06 +0000 (Tue, 22 Nov 2011)
Log Message:
-----------
Fix directories listing - patch from A. Piesk

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

Modified: trunk/tora/src/tobrowserdirectorieswidget.cpp
===================================================================
--- trunk/tora/src/tobrowserdirectorieswidget.cpp	2011-11-21 22:36:05 UTC (rev 4150)
+++ trunk/tora/src/tobrowserdirectorieswidget.cpp	2011-11-22 12:06:06 UTC (rev 4151)
@@ -47,7 +47,8 @@
 
 static toSQL SQLDirectoriesInfo("toBrowser:DirectoriesInformation",
                            "SELECT * FROM sys.all_directories\n"
-                           " WHERE directory_name = :f1<char[101]>\n"
+                           " WHERE (Owner = 'SYS' OR Owner = :f1<char[101]>)\n"
+                           " AND directory_name = :f2<char[101]>\n"
                            " ORDER BY owner, directory_name",
                            "Display information about directories by name");
 

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