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.
-- Ed Leafe
_______________________________________________
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]
