Problem with TBCDField using MSSQL 6.5

Jerry Adriane Gon?alve

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Problem with TBCDField using MSSQL 6.5

Hi,

Ive created a table on MSSQL 6.5 where a column is defined as
decimal(12,6).
Ive wrote an application to mantain this table using a request live TQuery.
When I clicked on "Add fields" options in the fields editor Delphi 3 was
create a TBCDField for the decimal(12,6) column.

My problem is:

When I type any value that has more than 4 decimal digits (e.g. 2.654321),
after post the value recorded in the table will have only 4 decimal digits.
In exemplified case the recorded value will be 2.654300.

How can I do to solve this problem ?

Thanks in advance.

Jerry - Brazil

Robert Kind

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Problem with TBCDField using MSSQL 6.5

Core of your problem is that TBCDField uses currency type for storing data.
You have to set EnableBCD=False in your BDE Alias configuration.
Then TFloatField will be created instead of TBCDField which is using double
type.

Quote

Jerry Adriane Gon?alves wrote:
> Hi,

> Ive created a table on MSSQL 6.5 where a column is defined as
> decimal(12,6).
> Ive wrote an application to mantain this table using a request live TQuery.
> When I clicked on "Add fields" options in the fields editor Delphi 3 was
> create a TBCDField for the decimal(12,6) column.

> My problem is:

> When I type any value that has more than 4 decimal digits (e.g. 2.654321),
> after post the value recorded in the table will have only 4 decimal digits.
> In exemplified case the recorded value will be 2.654300.

> How can I do to solve this problem ?

> Thanks in advance.

> Jerry - Brazil
Jerry Adriane Gon?alves wrote:
> Hi,

> Ive created a table on MSSQL 6.5 where a column is defined as
> decimal(12,6).
> Ive wrote an application to mantain this table using a request live TQuery.
> When I clicked on "Add fields" options in the fields editor Delphi 3 was
> create a TBCDField for the decimal(12,6) column.

> My problem is:

> When I type any value that has more than 4 decimal digits (e.g. 2.654321),
> after post the value recorded in the table will have only 4 decimal digits.
> In exemplified case the recorded value will be 2.654300.

> How can I do to solve this problem ?

> Thanks in advance.

> Jerry - Brazil

Other Threads

1. Date conversion using TQuery and MSSQL 6.5

2. using TEXT columns with MsSQL 6.5 and Delphi 2.0

3. Using D3 C/S with MSSQL 6.5

4. Error trying to insert record using BDE on MSSQL 6.5

5. Deadlock when using mssql 6.5

6. Connect to MSSQL 6.5 using TCP Sockets

7. MSSQL 7.0 x MSSQL 6.5 (Inserted, Deleted)

8. Standard problem - BDE 3.5 + MSSQL 6.5 + IDENTITYColumn = Insert Fails

9. Problem ADO and MSSQL 6.5

10. Upgrading MSSQL 6.5 to 7.0 - TStoredProc problem!