Alex
Delphi developers cannot use any BCD, Numeric type for anything other than
money for any database not just MS SQL
I'd be interested to see what happens with no decimal points
Regards
Neven
----- Original Message -----
From: Alex Kouznetsov <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Friday, 5 May 2000 13:17
Subject: Re: [DUG]: SQL 7 decimal comes as currency in delphi
> 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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
