[ wxwindows-Bugs-1729535 ] wxDbTable don't handle SQL_C_TINYINT

[SourceForge.net]

Bugs item #1729535, was opened at 2007-06-01 17:25
Message generated for change (Comment added) made by bcesarano
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109863&aid=1729535&group_id=9863

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Database
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Baldassarre Cesarano (bcesarano)
Assigned to: Nobody/Anonymous (nobody)
Summary: wxDbTable don't handle SQL_C_TINYINT

Initial Comment:
1) Il you define a column type SQL_C_TINYINT (1 byte) or SQL_C_SHORT (2 bytes) the "CreateTable" function make a "long Integer" column (4 bytes).

2) If you make the table with sql code
("CREATE TABLE Foo (... FieldX AS Byte...)") subsequently is not possible to query this value with wxDbTable (See the file dbtable.cpp in the function wxDbTable::BuildWhereClause in the switch is not contemplated a 1 byte NUMERIQUE value, only SQL_C_CHAR/SQL_C_WCHAR but is a string "%s")

Ciao

----------------------------------------------------------------------

>Comment By: Baldassarre Cesarano (bcesarano)
Date: 2007-06-01 17:34

Message:
Logged In: YES 
user_id=349664
Originator: YES

I have tested MS-Access 2003 and MS-SQL Server 2000 too

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109863&aid=1729535&group_id=9863