Board index » delphi » Open source dbexpress driver for ODBC (dbxoodbc) problem with USMALLINT fields

Stefano

Delphi Developer
Sun, 26 Sep 2004 14:40:37 GMT

Open source dbexpress driver for ODBC (dbxoodbc) problem with USMALLINT fields

I have defined a Pervasive.SQL 2000 Table with some USMALLINT (Unsigned smallint) fields.
In a Delphi application with ADO the persistent fields of the table are defined as TWordField and all works correctly.
If I use dbExpress with the open source Odbc driver the fields of the table are defined as TSmallintField and I have problems handling records containg values greater then 32767.
How can I solve this problem?

Bye.

 
Edward Benso

Delphi Developer
Sun, 26 Sep 2004 17:48:24 GMT

Re:Open source dbexpress driver for ODBC (dbxoodbc) problem with USMALLINT fields


I do not have Pervasive SQL, so I cannot test this.

Since the source code for my DbExpress driver is available,
please feel free to fix the problem yourself and then kindly post
the patch on SourceForge so that other developers can benefit.

Later I will integrate your fix into the standard release.

Edward Benson.

Quote
"Stefano" <vecchs...@supereva.it> wrote in message news:3cb3de65$1_2@dnews...

> I have defined a Pervasive.SQL 2000 Table with some USMALLINT (Unsigned smallint) fields.
> In a Delphi application with ADO the persistent fields of the table are defined as TWordField and all works correctly.
> If I use dbExpress with the open source Odbc driver the fields of the table are defined as TSmallintField and I have problems

handling records containg values greater then 32767.
Quote
> How can I solve this problem?

> Bye.

Other Threads

1. DbxoODBC 2.06 - Kylix/Delphi Open Source ODBC dbExpress driver

2. Dbxoodbc Open source dbexpress works on multi-tier ?

3. Open Source DbExpress Driver for ODBC

4. Open Source project for DbExpress drivers

5. Any disadvantage of using dbExpress ODBC driver over native DBMS driver

6. Problem with dbExpress and InterBase Open Source

7. Edward Benson. Problems with dbExp Open ODBC driver

8. Problems with number fields on Oracle 8i and BDE+ODBC driver

9. Date field problems with ODBC driver

10. dbExpress sample driver sources on sourceforge