cipients 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
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
>
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 da
select convert (real, my_field) from my_table
- Original Message -
From: Alex Kouznetsov <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Friday, 5 May 2000 11:16
Subject: Re: [DUG]: SQL 7 decimal comes as currency in delphi
> > Wh
-
> From: Dennis Chuah <[EMAIL PROTECTED]>
> To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
> Sent: Friday, 5 May 2000 09:22
> Subject: RE: [DUG]: SQL 7 decimal comes as currency in delphi
>
>
> >
> > I am meaning you can try
> >
> >
Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> > Behalf Of Alex Kouznetsov
> > Sent: Thursday, 4 May 2000 20:44
> > To: Multiple recipients of list delphi
> > Subject: Re: [DUG]: SQL 7 decimal comes as currency in delphi
> >
> >
> >
f Of Alex Kouznetsov
> Sent: Thursday, 4 May 2000 20:44
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: SQL 7 decimal comes as currency in delphi
>
>
> I just do "select * from my_table". Table has about 40
> columns. 2 of them
> are d
TECTED]>
Sent: Thursday, 04 May, 2000 3:30 PM
Subject: RE: [DUG]: SQL 7 decimal comes as currency in delphi
>
> Haven't hit this problem before, but you can try converting to varchar ...
> as in CONVERT (varchar(30), DecimalField).
>
> Regards,
> Dennis.
>
>
Haven't hit this problem before, but you can try converting to varchar ...
as in CONVERT (varchar(30), DecimalField).
Regards,
Dennis.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Alex Kouznetsov
> Sent: Thursday, 4 May 2000 16:55
> To: Multipl
