At 16:46 Wednesday, 18.01.2006 +0000, Rick Roen wrote:

>Jason,
>DATE=YYYY-MM-DD
>NUMERIC(18,3)=,0.000
>
>This way all DATES get formatted the same way, unless they are
>overridden with a more specific field specifier.

Hi,

this is already possible. Go to your IB_Connection component and set
FieldEntryTypes to include fetDomain (not sure what it's called
exactly). Then you can specify your defaults for domain types in the
ColumnAttributes and FieldsDisplayFormat properties. Have a look at
the FielEntryTypes, it allows you to activate this for SQL data types, too.
You can override these defaults in your IB_Query components or for a
specific field name. If you use a syntax like
TableName.FieldName=formatString then your setting will be used for
this one column only.

HTH,
Markus