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
