# HG changeset patch
# User catherine@Elli.myhome.westell.com
# Date 1238077291 14400
# Node ID c897add05eb1d244df8efb957445e64d089ef431
# Parent  0d16630d8e045c0ed88636b7c34f9ae063389ae3
fixed grep bug

diff -r 0d16630d8e04 -r c897add05eb1 sqlpython/sqlpyPlus.py
--- a/sqlpython/sqlpyPlus.py	Wed Mar 25 18:42:22 2009 -0400
+++ b/sqlpython/sqlpyPlus.py	Thu Mar 26 10:21:31 2009 -0400
@@ -1435,8 +1435,10 @@
         targets = [] 
         for target in targetnames:
             if '*' in target:
-                self._execute("SELECT owner, table_name FROM all_tables WHERE table_name LIKE '%s'%s" %
-                                  (target.upper().replace('*','%')), arg.terminator)
+                self._execute("""SELECT owner, object_name FROM all_objects 
+                                 WHERE object_type IN ('TABLE','VIEW')
+                                 AND object_name LIKE '%s'%s""" %
+                              (target.upper().replace('*','%'), arg.parsed.terminator))
                 for row in self.curs:
                     targets.append('%s.%s' % row)
             else: