> Why not convert to a float?
How ?
If I run a query 'select my_decimal_column from my_table' I get result set
with a Fields[0].DataType=ftCurrency.
Regards
Alex
>
> Regards Neven
> N.K. MacEwan B.E. E&E
> [EMAIL PROTECTED]
>
> ----- Original Message -----
> 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
> >
> > select convert (varchar(30), my_field) from my_table
> >
> > This will comeback as string, and you can convert that to a Double.
> Slower,
> > but ought to work.
> >
> > Regards,
> > Dennis.
> >
> > > -----Original 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
> > >
> > >
> > > I just do "select * from my_table". Table has about 40
> > > columns. 2 of them
> > > are decimals and they both come up as currencies.
> > >
> > > ????????
> > >
> > > ----- Original Message -----
> > > From: "Dennis Chuah" <[EMAIL PROTECTED]>
> > > To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
> > > 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.
> > > >
> > > > > -----Original Message-----
> > > > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED]]On
> > > > > Behalf Of Alex Kouznetsov
> > > > > Sent: Thursday, 4 May 2000 16:55
> > > > > To: Multiple recipients of list delphi
> > > > > Subject: [DUG]: SQL 7 decimal comes as currency in delphi
> > > > >
> > > > >
> > > > > Hi
> > > > >
> > > > > MSSQL 7 decimal data type (length=9,precision=18,scale=9) is
> > > > > recognised by
> > > > > D5 as a currency data type. Accordingly decimals beyond 4th
> > > > > position are
> > > > > lost.
> > > > >
> > > > > Does anyone know where the problem lies and is there any way
> > > > > around this ?
> > > > >
> > > > > Thanks in advance
> > > > > Alex
> > > > >
> > > > >
> > > > >
> > > > > --------------------------------------------------------------
> > > > > -------------
> > > > > 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
> > >
> >
>
> --------------------------------------------------------------------------
> -
> > 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
