While we wait for Jason on the performance hit possibilities I have
another question.

I got the fetSQLType working but it only responds to the generic
number types like DECIMAL (NUMERIC seems to be converted to
DECIMAL), INTEGER, SMALLINT etc.

There doesn't seem to be any facility to read the scale and
precision, in fact if I am reading the source correctly, all of this
is chopped off in cases where the Name part contains a "(" char.

To me, this seems of little practical value with scaled number types
since I don't want to format DECIMAL(18,2) the same as DECIMAL(18,4).

The Domains seem to be the way to go since they are specific to a
scale.

Does anyone have any experience with using Domains for this type of
thing. I don't want to write the program using them for formatting
and then find that the performance hit is to great to be useful.

Rick

--- In IBObjects@yahoogroups.com, "Rick Roen" <rick@l...> wrote:
>
> Jason,
>
> I have a feature request if it seems feasable.
>
> I use the IB_Connection.DefaultValues string list extensively in
my
> programs. First of all, its a great idea for centering all the
> formats in one place!
>
> I find myself using the same format over and over with different
> field names (INVOICE_DATE=YYYY-MM-DD, ETA_DATE=YYYY-MM-DD etc. ),
so
> I thought it might be useful if we could also specify generic data
> types like:
>
> 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.
>
> I wanted to store this StringList in the database so the user can
> customize the format appearance and this would make it much easier
> for them to understand.
>
> Let me know what you think.
>
> Rick
>