[DUG] SQL question

[Mark Howard]

Leigh
The answer is No.  Maybe I should do some self-training along these lines  :-/
Mark
On Fri, 24 Jun 2005 12:13:36 +1200, Leigh Wanstead <leighw at softtech.co.nz> wrote:

> Hi Mark,
>
> Are you using TField descendents? If the answer is yes, maybe you can try
> set DisplayFormat field.
>
> Regards
> Leigh
> http://www.salenz.com
>
> -----Original Message-----
> From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz] On
> Behalf Of Mark Howard
> Sent: Friday, 24 June 2005 11:23 a.m.
> To: delphi at ns3.123.co.nz
> Subject: [DUG] SQL question
>
> Can anyone suggest a way to return a figure of (say) 32.30 from a SQL SELECT
> statement, instead of the 32.3?
> I would like the returned number formatted as I'm just sending the dataset
> straight out to a CSV file.
>
> I'm using DBISAM but I'm willing to try ANY suggestions to see if they work.
>
> TIA
>
> Mark
>
> --
> Forest Production Systems Ltd
> Creators of PSLog - A harvesting information system www.pslog.co.nz
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.8.0/27 - Release Date: 23/06/2005
>
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
>
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
>
>
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
>
>
>



-- 
Forest Production Systems Ltd
Creators of PSLog - A harvesting information system
www.pslog.co.nz


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.0/27 - Release Date: 23/06/2005