Hi Mark
I've played around with CSV files with Excel a bit and found Excel to be a
bit frustrating. If you format '32.3' as '32.30' Excel will only display the
value correctly as text. Presumably the end user only wants to "look" at the
data, rather than edit it, sum columns etc.
If the use needs to do a bit more useful stuff with the data inside Excel,
your best solution would be to output an XLS file with correct cell
formatting instead of a CSV file. There are some native Delphi free
components available to help do this. TXLSRead/TXLSWrite I haven't used them
myself, but I hear they work well.
Todd.
----- Original Message -----
From: "Mark Howard" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, June 24, 2005 11:23 AM
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
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.7.10/25 - Release Date: 21/06/2005
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
