I think when I was looking at DBISAM it had a "CAST" function that I used to convert floats to strings.
Jeremy -----Original Message----- From: "Traci Sumpter" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>, "'NZ Borland Developers Group - Delphi List'" <[email protected]> Cc: Date: Fri, 24 Jun 2005 13:35:42 +1200 Subject: RE: [DUG] SQL question > Poor Boy... > > The reason I ask is that there are DBISAM type databases. However you > are > using DBISAM it self wich may leave you in a bad situation. > > Formatting on most databases is able to be done with SQL functions. I > have > had a look and the functions available on DBISAM is lacking. > > Are you using delphi or are you trying to do a direct query. You may > need > to perform formatting on the PHP/Delphi/ other end product. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Mark Howard > Sent: Friday, 24 June 2005 12:43 p.m. > To: [email protected] > Subject: Re: [DUG] SQL question > > 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 > > _______________________________________________ > Delphi mailing list > [email protected] > http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
