dabo Commit
Revision 2720
Date: 2007-01-18 11:03:04 -0800 (Thu, 18 Jan 2007)
Author: Uwe_Grauer
Changed:
U trunk/dabo/db/dbFirebird.py
Log:
replaced "like" with starting with as "starting with" can use an index.
Diff:
Modified: trunk/dabo/db/dbFirebird.py
===================================================================
--- trunk/dabo/db/dbFirebird.py 2007-01-18 16:12:58 UTC (rev 2719)
+++ trunk/dabo/db/dbFirebird.py 2007-01-18 19:03:04 UTC (rev 2720)
@@ -88,7 +88,7 @@
if includeSystemTables:
whereClause = ''
else:
- whereClause = "where rdb$relation_name not like 'RDB$%'
"
+ whereClause = "where rdb$relation_name not starting
with 'RDB$' "
tempCursor = self._connection.cursor()
tempCursor.execute("select rdb$relation_name from rdb$relations
"
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev