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
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
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
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,
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
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.
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
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
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,
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
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
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,
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
13 matches
Mail list logo