Subject | Re: [IBO] IB_Connection.fetSQLType |
---|---|
Author | H.Klomann |
Post date | 2002-04-18T09:43:36Z |
Hi Geoff,
thanks for reply !
What I wanted to getting work is to use fetSQLType in the same
manner as fetDomainName.
If I set IB_Connection.FieldEntryTypes := [fetDomainName] , and then
put an entry in IB_Connection.ColumnAttributes like VARCHAR=YESLIKE
this works fine !
I thought, it would work the same way if I set IB_Connection.FieldEntryTypes := [fetSQLType]
and in IB_Connection.ColumnAttributes I put entry like
VARCHAR=YESLIKE
Am I totally wrong ?
Thanks,
Harald
Geoff Worboys schrieb:
thanks for reply !
What I wanted to getting work is to use fetSQLType in the same
manner as fetDomainName.
If I set IB_Connection.FieldEntryTypes := [fetDomainName] , and then
put an entry in IB_Connection.ColumnAttributes like VARCHAR=YESLIKE
this works fine !
I thought, it would work the same way if I set IB_Connection.FieldEntryTypes := [fetSQLType]
and in IB_Connection.ColumnAttributes I put entry like
VARCHAR=YESLIKE
Am I totally wrong ?
Thanks,
Harald
Geoff Worboys schrieb:
>
> > anyone knows to configure IB_Connection.fetSQLType ?
>
> > I tried:
> > -------
> > IB_Connection.fetSQLType=TRUE
> > IB_Connection.ColumnAttributes:SQL_VARYING=YESLIKE
>
> > No Success !?
>
> It works from IB_Column.SQLTypeSource - but removes anything following
> the first bracket. So if you look at IBA_Column.IMP
> TIB_Column.GetSQLTypeSource you will find that it is looking for
> things like...
>
> INTEGER
> CHAR
> VARCHAR
> NUMERIC
> DECIMAL
> DOUBLE PRECISION
> DATE
> TIME
> TIMESTAMP
>
> Note that it is not possible to determine DECIMAL vs NUMERIC
> accurately (due to limitations in the definitions stored by IB/FB).
> IBO makes the following assumptions...
>
> SQL_QUAD,
> SQL_QUAD_,
> SQL_INT64,
> SQL_INT64_: Result := 'DECIMAL ...
> SQL_DOUBLE,
> SQL_DOUBLE_: Result := 'NUMERIC ...
> SQL_FLOAT,
> SQL_FLOAT_: Result := 'NUMERIC ...
> SQL_LONG,
> SQL_LONG_: Result := 'DECIMAL ...
> SQL_SHORT,
> SQL_SHORT_: Result := 'DECIMAL ...
>
> This means that you need to be careful, since a declaration of
> NUMERIC(18,0) will actually turn up as DECIMAL inside IBO.
>
> hth
>
> --
> Geoff Worboys
> Telesis Computing
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/