[Gambas-devel] gb.odbc new

[Daniel Campos]

Thank you, Andrea!. It will take some days for me to test it again
(I'm away from the informix machine), but I will tell you my tests
when they're done...

Regards,

D. Campos

2005/11/3, Andrea Bortolan <andrea_bortolan at ...112...>:
> Hi all,
> here the new version of the odbc driver.
> I added a check in order to call SQLFetch instead the
> SQLFetchScroll api when the odbc driver does not
> support the SQLFetchscroll call.
> If the driver does not support SQLFetchscroll then
> SQLFetch is called and the result set cannot be
> refetched, this can be a problem if the application
> fetchs the rows till the end and after try to refetch
> it from the beginning, odbc will rise the end of data
> error.(This is why I initially used only the
> SQLFetchScroll)
> This problem occurs using i.e. both, Database example
> and Gambas Database Manager because they need to fetch
> all the result set to know the numbers of rows and
> then refetch all the rows again to retrieve the data.
> To avoid this problem the application should allocate
> the result set row by row fetching one row at time and
>  not creating the whole result set based on the rows
> number.
> Let me know if this can work correctly on Informix.
> Ciao, Andrea
>
>
>
>
>
>
>
> ___________________________________
> Yahoo! Mail: gratis 1GB per i messaggi e allegati da 10MB
> http://mail.yahoo.it
>
>