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
