Problem with DBExpress

CARLOS NEVES · Post by **CARLOS NEVES** » Tue Jul 11, 2006 12:53 pm

Hi,

I work with Oracle 9i and Delphi 2006, the components “TSQLQuery”, “TStoredProc” and “TSQLDataSet” of DBExpress recognize columns “Integer” and “Number” as “TFMTBCDField”, but the problem is “TDBChart” don´t work with this type.
Exists any solution for this?

Thanks...
Carlos Neves

Narcís · Post by **Narcís** » Wed Jul 12, 2006 1:49 pm

Hi Carlos,

I'm afraid you'll have to populate the series manually, iterating on the recordset and using Add or AddXY methods to populate the series.

CARLOS NEVES · Post by **CARLOS NEVES** » Wed Jul 12, 2006 2:40 pm

Narcís, it´s one solution

narcis wrote:Hi Carlos,

I'm afraid you'll have to populate the series manually, iterating on the recordset and using Add or AddXY methods to populate the series.

But, i working in a migration of BDE for DBExpress. This project contain 25 TBChart, for this i post one sugestion for this.

Thanks for Reply.
Carlos Neves

Narcís · Post by **Narcís** » Mon Jul 17, 2006 7:40 am

Hi Carlos,

BCD type is supported but not FMTBCD, we will add it.

In the meantime, manually adding the field manually should work fine. This is not being added at the editor's list but you can try using:

Code: Select all

Series1.YValues.ValueName := 'MyFMTBCDField';