johnf wrote:
> On Friday 20 February 2009 09:18:31 pm johnf wrote:
>
>> On Friday 20 February 2009 08:55:30 pm tim awa wrote:
>>
>>> On Sat, Feb 21, 2009 at 12:50 PM, tim awa <[email protected]> wrote:
>>>
>>>> postgresql-8.3.6-1-windows.exe
>>>> psycopg2-2.0.8.win32-py2.5-pg8.3.4-release.exe
>>>>
>>> Could this be the culprit?
>>>
>>> psycopg2 for pg8.3.4 and what I have is postgresql 8.3.6-1
>>>
>> That is new! I'm not sure. But I'll try and load windows with the latest
>> version of Postgres tomorrow morning just to check. I'm sure I'll some
>> time tomorrow have something that works correctly.
>>
>
> I download the latest Postgres. I was still able to use getTables() to work
> without changes. However, the moment I used ClassDesigner it did not. Same
> error you guys were getting. Made the changes on the quoting and sure enough
> ClassDesigner started working. Retested, using getTables() independent of
> ClassDesigner and again it worked. Hmmmm?
>
> So I have posted the changes. As always please test and report any issues.
>
John what about the changes to dbmssql? Could you include them too?
It's just :
def getTables(self, cursor, includeSystemTables=False):
# jfcs 11/01/06 assumed public schema
# cfk: this worries me: how does it know what db is being used?
# tempCursor.execute("select name from sysobjects where xtype =
'U' order by name")
dbName = self.database
-----------------------------------> dbName = str(self.database)
and :
def getFields(self, tableName, cursor):
""" Returns the list of fields of the passed table
field: ( fieldname, dabo data type, key )
"""
# fairly standard way of getting column settings
# this may be standard enough to put in the super class
dbName = self.database
---------------------------------> dbName = str(self.database)
---------------------------------> tableName = str(tableName)
Or whatever other code that gets dbName and tableName to be strings and
not unicode.
Thx
Ricardo
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]