Thanks Neven.

This simply means that Delphi developers cannot use MSSQL 7.0 decimal data
type. At least it is pointless, as money type is shorter than decimal, and
money is OK if no more than 4 positions after decimal point required. And if
more precision needed then real type may be some kind of a solution.

Alex


----- Original Message -----
From: "Neven MacEwan" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Friday, 05 May, 2000 11:20 AM
Subject: Re: [DUG]: SQL 7 decimal comes as currency in delphi


> Alex
>
> this from D5 help
>
> 'Delphi does not have a native type for BCD. Therefore, TBCDField converts
> the data from a BCD value to a Currency value when it fetches the data
from
> the database table, and converts it from a Currency value to a
binary-coded
> decimal value when it posts the data to the database'
>
> basically Delphi assumes all numeric types decimal, numberic are
currencies
>
> Regards
> Neven
>
> --------------------------------------------------------------------------
-
>     New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
>                   Website: http://www.delphi.org.nz

---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz

Reply via email to