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/

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

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/

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)