Użytkownik Ed Leafe napisał: > On Aug 10, 2010, at 4:07 AM, Jacek Kałucki wrote: > > >> Of course I can, but then, even updates stop working, >> because controls uses boolean type, backend recive >> command like "update table set field = True", instead >> of "update table set field = 1". >> It's better to leave bit type mapped as integer, >> to make updates working, and even inserts are working >> if I set all table fields to its default values with DefaultValues property. >> > > That sounds like a shortcoming of the dbapi adapter, which is supposed > to handle things like this. The MySQLdb adapter does this correctly; MySQL > doesn't have a boolean type, so it will convert "set field = True" to "set > field = 1" for you. Likewise, it handles date/time conversion, too. >
Oh, maybe MySQL adapter does, don't know, I don't use MySQL. This is thread about _MsSQL_, and it doesn't remap types. This is a logfile excerpt: "DBQueryException encountered in save(): SQL Server message 207, severity 16, state 1, line 1: Invalid column name 'True'." -- Regards Jacek Kałucki _______________________________________________ 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]
