[Gambas-devel] gb.odbc new

[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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ChangeLog
Type: application/octet-stream
Size: 624 bytes
Desc: 2127288286-ChangeLog
URL: <http://lists.gambas-basic.org/pipermail/devel/attachments/20051103/d5bdbdb6/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: main.c
Type: text/x-csrc
Size: 58151 bytes
Desc: 943189714-main.c
URL: <http://lists.gambas-basic.org/pipermail/devel/attachments/20051103/d5bdbdb6/attachment.c>