Why not convert to a float?
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
