BUG? dbExpress interprets DEC(18,0) as wrong field type

Kevin Jesshope \(remove the furphy\)

Delphi Developer

Sun, 29 Feb 2004 07:50:28 GMT

BUG? dbExpress interprets DEC(18,0) as wrong field type

I originally posted this in bp.p.delphi.database.dbexpress and got zero
responses so I am reposting here.

When accessing Interbase 6 (dialect3) using dbExpress the components
TSQLQuery, TSQLClientDataSet TSQLTable and TSQLClientDataSet all interpret a
DEC(18,0) and NUMERIC(18,0) in IB6 as TFMTBCDField.
This causes 10000 to be displayed as '1000='.

Using a TIBClientDataSet the same field is seen as a TLargeIntField and
things work fine.

Is this a bug in dbExpress or am I missing something?

--
Regards

Kevin Jesshope
In Touch Computer Support
Adelaide, South Australia

Never be afraid to try something new; remember, amateurs built the Ark, and
professionals built the Titanic.

Robert Schiec

Delphi Developer

Sun, 29 Feb 2004 17:19:34 GMT

Re:BUG? dbExpress interprets DEC(18,0) as wrong field type

In article <3b9ea483_1@dnews>, Kevin Jesshope (remove the furphy)
wrote:

Quote

> Is this a bug in dbExpress or am I missing something?

I don't have a real answer for you, but there are issues with 64 bit
integers and there support. DBExpress is lowest common denominator type
of solution. IBX is specifically written for Interbase ..

hth

Robert Schieck (TeamB)
MER Systems Inc.
Inprise/Borland/InterBase Search Engine
http://www.mers.com/searchsite.html

Other Threads

1. TSQLClientDataSet sees IB DEC(18,0) as wrong field type

2. IB Numeric(18,0) field shows ?

3. IBX6.07 (Delphi 6) Problems with decimal(18, 5) fields and SQL dialect 3

4. ADO returning wrong field types with Oracle table

5. Delphi 4 creates wrong field type

6. dbexpress error: invalid field type

7. The database data type is numeric(18,6),but the field created by tadodataset is TBCDFIELD,so its scale only up to 4.

8. MySQL Autoincrement fields dbExpress bug - a solution?

9. ADO bug - colon/word inside double quotes inside string being interpreted as param

10. Type Library uses wrong types