At 06:57 PM 28/05/2003 +0200, you wrote:

>Hello all
>Can some one please help me by telling me
>Why the FieldsDisplayFormat property does not have any impact
> that come out from simple script as this:
>"Select count(*) as rec_count from table..."
>
>I set the FieldsDisplayFormat to
>"numeric=0.00"
>"integer=0"
>and whene i display it. its still as numeric(18,4) which mean #.####

You don't use FieldsDisplayFormat to specify the format of the data type,
but of the column itself. So for your query above, the FieldsDisplayFormat
would be

rec_count=0

If you had a numeric(18,4) column in your output, named MyNumCol, then to
get the effect you want you would enter it as

MyNumCol=0.00

hth
Helen