[DUG] SQL question

[Daryl Marsden]

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: 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
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

**********************************************************************
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
**********************************************************************