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]

Reply via email to