Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
Specifying column attributes in SQL |
Thu, Oct 26 2006 7:38 AM | Permanent Link |
Is it possible to set things like the DisplayFormat of a column in the
SQL? So it would be something like: SELECT myColumn DISPLATFORMAT ",0.00" FROM myTable /Matthew Jones/ | |
Thu, Oct 26 2006 8:53 AM | Permanent Link |
"Ralf Mimoun" | Matthew Jones wrote:
> Is it possible to set things like the DisplayFormat of a column in the > SQL? So it would be something like: > > SELECT myColumn DISPLATFORMAT ",0.00" FROM myTable No. The server/db system is not responsible now the data are shown. Ralf |
Thu, Oct 26 2006 9:57 AM | Permanent Link |
Okay, thanks. While you are right, it is the database component that is
automatically creating the TField items so it would be nice to be able to hint it somehow and not have to do a separate process. But on the other hand it does allow it to be more efficiently changed I suppose. /Matthew Jones/ | |
Thu, Oct 26 2006 11:00 AM | Permanent Link |
Chris Erdal | mattjones@cix.co.uk (Matthew Jones) wrote in
news:memo.20061026145228.412C@nothanks.nothanks.co.uk: > Okay, thanks. While you are right, it is the database component that > is automatically creating the TField items so it would be nice to be > able to hint it somehow and not have to do a separate process. The database component is just a way of simplifying (via Delphi) our access to data in the DBISAM database tables. The same DBISAM database may need to feed dates and money data to a user in the USA and in France, and they want the it shown shown differently. So it is logical (and optimal) that only universally-coded data should be returned from the database to our programs, which in turn may be set up to format what they receive in the way each user wants to see it. -- Chris (XP-Pro + Delphi 7 Architect + DBISAM 4.24 Build 1) |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |