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
> > 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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
