Re: [Firebird-odbc-devel] RE: DECIMAL fields AND Visual Foxpro

[Andrea C. P. <ac...@bi...>]

Hi,

probably it is a ODBC driver problem.

I tried it with GEMINI and VFP6 and works fine.

--
Andrea Chiado Piat
Bit Informatica s.r.l.
Progettazione e Sviluppo


""B. Schulte"" <sc...@de...> ha scritto nel messaggio
news:3D136E4A.20165.28BCF0@localhost...
> Hi,
>
> I'm sorry, but I can't reproduce this behaviour.
> By the way: the are is real DECIMAL-type in FireBird. It is internally
> converted to NUMERIC or DOUBLE (and also shown as this).
> maybe you can tell me step by step what you did.
> I remember that I saw this kind of error also with the 5.6-odbc-driver,
> that came with the first release for Interbase 6.0.
> Maybe this is a FoxPro-specific problem (maybe not definitively)
>
>   B. Schulte
>
>
>
> >
> > Hello:
> >
> >
> > In visual foxpro when you execute a Statement with sqlexec like this:
> >       sqlexec( gnHConn,"SELECT SUM(field) FROM TABLE", "CURSOR")
> > if the field in the sum is a DECIMAL field in Firebird, Visual Foxpro
> > converts it in Character because the driver returns JDBC_BIGINT as
> > column type i have a little fix for this issue and return JDBC_DECIMAL
> > instead of SQL_BIGINT for DECIMAL FIELDS( i 4m very pleased if any can
> > confirm to me that this fix is correct ):
> >
> >
> > Sqlda.h:
> >
> > Change:
> >  static int getSqlType (int iscType, int subType);
> >  static const char* getSqlTypeName (int iscType, int subType);
> > to :
> >
> >  static int getSqlType (int iscType, int subType, int sqlScale);
> >  static const char* getSqlTypeName (int iscType, int subType, int
> >  sqlScale);
> >
> >
>
>
>
> -------------------------------------------------------
> Sponsored by:
> ThinkGeek at http://www.ThinkGeek.com/
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>