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
