Subject Re: [IBDI] ANN: Gemini ODBC v.1.1
Author Aleksey Karyakin
In fact, Interbase doesn't allow to create "pure" INT64 data columns (at
least for now), it always will be NUMERIC(xx,yy). Such fields will be
reported as NUMERIC both in catalog functions and in result sets. The
modification makes sense only in one case: database of dialect3, result set
with aggregate function on some integer field e.g.

select sum(some_integer_field) from some_table

Interbase v6 dialect 3 will always convert result column to "pure" INT64. In
such case the driver reports that column as SQL_DOUBLE.

Regards,
Aleksey

----- Original Message -----
From: "Claudio Valderrama C." <cvalde@...>
To: <IBDI@yahoogroups.com>
Sent: Wednesday, February 28, 2001 4:09 AM
Subject: RE: [IBDI] ANN: Gemini ODBC v.1.1


> When you wrote:
> <
> INT64 columns were reported as SQL_BIGINT. This is correct behavior,
> however, MS ODBC DM doesn't allow application to use SQL_BIGINT type
working
> with ODBC 2.x drivers. Now such columns are reported as SQL_DOUBLE;
> >
>
> Does this mean that the driver won't report INT64 any more or that there's
> an ODBC 3.X specification where you continue reporting INT64 as
SQL_BIGINT,
> so the type reported will depend ultimately on the ODBC level asked by
cthe
> lient app? I don't follow the ODBC versions and specifications, so I'm
> asking.
>
> C.
>
> > -----Original Message-----
> > From: Aleksey Karyakin [mailto:karyakin@...]
> > Sent: Martes 27 de Febrero de 2001 6:40
> > To: IBDI@yahoogroups.com
> > Subject: [IBDI] ANN: Gemini ODBC v.1.1
> >
> >
> > Hello,
> >
> > New version 1.1 of Gemini Interbase ODBC Driver is available at
> > http://www.geocities.com/ibdatabase/.
> > This build will fix several minor bugs and incompatibility issues with
> > Access and Crystal Reports. For full list of changes see link above.
> > Installing evaluation version 1.1 over any previous version (up
> > to 1.0) will
> > extend evaluation period for next 30 days from the first installation of
> > 1.1.
> >
> > Regards,
> > Aleksey Karyakin
> >
> > Community email addresses:
> > Post message: IBDI@onelist.com
> > Subscribe: IBDI-subscribe@onelist.com
> > Unsubscribe: IBDI-unsubscribe@onelist.com
> > List owner: IBDI-owner@onelist.com
> >
> > Shortcut URL to this page:
> > http://www.onelist.com/community/IBDI
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>