[Gambas-devel] gb.odbc new

[Andrea Bortolan]

I'll wait for your feedback !
Ciao.

Daniel Campos <dcamposf at ...176...> ha scritto: 
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 :
> 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
>
>


-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Gambas-devel mailing list
Gambas-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-devel

		
---------------------------------
Yahoo! Messenger: chiamate gratuite in tutto il mondo 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/devel/attachments/20051103/6f7028d2/attachment.html>