[Gambas-user] Compilation hangs on QT4 with Ubuntu 18.04.

KKing kicking177 at gmail.com
Sun Apr 4 12:23:43 CEST 2021


thanks @zxMarce

I don't think there is a huge impetus to make mdbtools a fully 
functioning sql engine so cursors may well not be built in or planned. 
Most of the efforts seem to be around allowing extraction of data from 
mdb or accdb to allow transfer to other systems. Maybe for gambas 
mdbtools "we" could make use of separate initial call of e.g.
     select COUNT(*) from Shippers
to get a record count... that works, though unfortunately
     select COUNT(*) from Shippers where CompanyName Like '%Pack%'
currently does not. There is a bug raised for on mdbtools as issue #251 
for this
possibly OTT but
     select * from Shippers where CompanyName Like '%Pack%'
does currently work, so could loop through all of records (and store) to 
get count first and then return the records?

Also bear in mind most distro's are shipping 0.9.1 whereas there are 
definite improvements in 0.9.2 and 0.9.3 Beta 1 on
https://github.com/mdbtools/

K.




More information about the User mailing list