[DUG] SQL question

[Allan, Samuel]

It is entirely possible that Excel (don't quote me) might simply ignore
the superfluous 0, even if it was there, and display it as 32.3, because
that is how Excel displays real numbers by default? It may be that the
only solution is to get your users to format their Excel spreadsheets
after import.

-----Original Message-----
From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
On Behalf Of Daryl Marsden
Sent: Friday, June 24 2005 1:06 p.m.
To: mhoward at pslog.co.nz; NZ Borland Developers Group - Delphi List
Subject: RE: [DUG] SQL question


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



_______________________________________________
Delphi mailing list
Delphi at ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi