Um. DBISAM
Mark
On Fri, 24 Jun 2005 11:52:24 +1200, Traci Sumpter <[EMAIL PROTECTED]> wrote:
What database?/. MySql, SQLServer, Oracle, other
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mark Howard
Sent: Friday, 24 June 2005 11:45 a.m.
To: [email protected]
Subject: Re: [DUG] SQL question
Traci
I've tried round and trunc but they both drop any trailing "0"'s I'v also
cast to Char but I can't find anything in the DBISAM documentation about
casting to a defined format of Char ie $$$.$$ or F5.2 etc I want to avoid
doing a complicated manipulation involving string lengths and substrings to
build what I want - if there is another way.
Thanks
Mark
On Fri, 24 Jun 2005 11:35:08 +1200, Traci Sumpter <[EMAIL PROTECTED]>
wrote:
Depends on the database, there are formating type functions like
to_char , round, trunc etc...
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Howard
Sent: Friday, 24 June 2005 11:23 a.m.
To: [email protected]
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
--
Forest Production Systems Ltd
Creators of PSLog - A harvesting information system www.pslog.co.nz
--
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
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
