Mark,
I've read a few of the other suggestions and I have 2 general comments
which may help.
1. rather than outputting to CSV "print" & format each line to the file
2. CSV=comma separated VALUES. 32.3 IS 32.30. 32.30 is how the value is
displayed. If you store irrelevant 0s then the resulting file will be bigger.
You could try fixed width field output (requiring even more space?)
What is the file to be used for? If input to spreadsheet or database then
there should be problem.
Daryl Marsden
Project Management Analyst
Environment Canterbury
P O Box 345
Christchurch
Phone (03) 365-3828 Ext 7141
Fax (03) 365-3194
http://www.ecan.govt.nz
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Mark Howard
Sent: Friday, 24 June 2005 11:23
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
--
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
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.ecan.govt.nz
**********************************************************************
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
