Re: [dabo-users] Mapping backend types to Dabo types (MsSQL)

2010-08-10 Thread Jacek Kałucki
Użytkownik Paul McNett napisał: You can set the biz.DataStructure explicitly, to tell Dabo that this field is boolean (B). I've taken to always setting DataStructure explicitly, even though it isn't always required. Of course I can, but then, even updates stop working, because

Re: [dabo-users] Mapping backend types to Dabo types (MsSQL)

2010-08-10 Thread Ed Leafe
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

Re: [dabo-users] Mapping backend types to Dabo types (MsSQL)

2010-08-10 Thread Jacek Kałucki
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

Re: [dabo-users] Mapping backend types to Dabo types (MsSQL)

2010-08-10 Thread Henning Hraban Ramm
Am 2010-08-10 um 15:49 schrieb Jacek Kałucki: Oh, maybe MySQL adapter does, don't know, I don't use MySQL. This is thread about _MsSQL_, and it doesn't remap types. He used MySQL only as an example. This is a logfile excerpt: DBQueryException encountered in save(): SQL Server message 207,

Re: [dabo-users] Mapping backend types to Dabo types (MsSQL)

2010-08-10 Thread Paul McNett
On 8/10/10 7:33 AM, Ed Leafe wrote: On Aug 10, 2010, at 9:49 AM, Jacek Kałucki wrote: Oh, maybe MySQL adapter does, don't know, I don't use MySQL. This is thread about _MsSQL_, and it doesn't remap types. The point was that *all* adapters should do that; that's the adapt portion of

Re: [dabo-users] Mapping backend types to Dabo types (MsSQL)

2010-08-10 Thread Jacek Kałucki
Użytkownik Henning Hraban Ramm napisał: This is a logfile excerpt: DBQueryException encountered in save(): SQL Server message 207, severity 16, state 1, line 1: Invalid column name 'True'. That yould also mean that MSSQL wants true, TRUE or TRUE() or whatever. You were close.

Re: [dabo-users] Mapping backend types to Dabo types (MsSQL)

2010-08-10 Thread John Fabiani
On Tuesday, August 10, 2010 10:50:12 am Paul McNett wrote: ...and if a particular adapter doesn't handle something we think it should, we can adapt to that in e.g. dbMSSQL.py. IIRC we've done this in the past with MySQL, postgresql, and sqlite. Paul What did we have to do postgres? Johnf

Re: [dabo-users] Mapping backend types to Dabo types (MsSQL)

2010-08-10 Thread Jacek Kałucki
Użytkownik Ed Leafe napisał: On Aug 10, 2010, at 9:49 AM, Jacek Kałucki wrote: Oh, maybe MySQL adapter does, don't know, I don't use MySQL. This is thread about _MsSQL_, and it doesn't remap types. The point was that *all* adapters should do that; that's the adapt portion

[dabo-users] Mapping backend types to Dabo types (MsSQL)

2010-08-09 Thread Jacek Kałucki
Hi, I have problem with mapping MS SQL 'bit' type to Dabo 'B' type and finally, Python boolean type. Pymssql return this type as boolean, but Dabo convert it by default to integer type, what is correct behaviour I think. Data updating works fine, but it fails when I'm trying to add new row,

Re: [dabo-users] Mapping backend types to Dabo types (MsSQL)

2010-08-09 Thread Kirby Leeper
Jacek, how did you get MS SQL to work? I can't even get it past the connection test in the wizard? Did you do something to the installation or, Ed, has there been a release that fixes my earlier threads that I missed? Thanks, Kirby Leeper 2010/8/9 Jacek Kałucki lab...@rz.onet.pl: Hi, I

Re: [dabo-users] Mapping backend types to Dabo types (MsSQL)

2010-08-09 Thread Jacek Kałucki
Użytkownik Kirby Leeper napisał: Jacek, how did you get MS SQL to work? I can't even get it past the connection test in the wizard? Did you do something to the installation or, Ed, has there been a release that fixes my earlier threads that I missed? Hi, I patched a bit, both

Re: [dabo-users] Mapping backend types to Dabo types (MsSQL)

2010-08-09 Thread Kirby Leeper
Thanks Jacek! Since I don't know anything about the Tracker could you please send me the patches as source. I can apply them here. I have pymssql 1.0.2 and Dabo 0.9.2 here. I can update Dabo also if needed. 2010/8/9 Jacek Kałucki lab...@rz.onet.pl: Użytkownik Kirby Leeper napisał: Jacek,

Re: [dabo-users] Mapping backend types to Dabo types (MsSQL)

2010-08-09 Thread Paul McNett
On 8/9/10 1:37 AM, Jacek Kałucki wrote: Hi, I have problem with mapping MS SQL 'bit' type to Dabo 'B' type and finally, Python boolean type. Pymssql return this type as boolean, but Dabo convert it by default to integer type, what is correct behaviour I think. Data updating works fine, but