Thanks Daniel - I think I'm missing the pont here. I want to look at
the data with a non-Delphi product and don't want to "lock" down the
field to a definite sql query - I re-use queries at runtime and feed
them with code, rather than having loads of them dotted around a
datamodule.
Second point - I want to query the data with PHP - again looking
at "raw" data.
Alan

> Hi,
>
> At May 25, 2004, 16:16, alan davies wrote:
>
> > I have tried the Cast() command and also different data types - e.g

decimal

> > 9,2; numeric 9,2 with no success. I can easily display the correct

format

> > in a Delphi grid but not in a web page. Can anyone help, please?
> [...snip...]
> > Alternatively, how can I force the stored data to respect the

precision and

> > scale settings?
>
> Use the field display format settings in Delphi.
>
> --
> Best regards,
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)
>
>
>
> ------------------------ Yahoo! Groups Sponsor --------------------~--
>
> Yahoo! Domains - Claim yours for only $14.70
> http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/67folB/TM
> --------------------------------------------------------------------~-
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>

Alan J Davies
Tel: +44 (0)1926 842069
Fax: +44 (0)1926 843755