Hello. On Sat, Mar 15, 2008 at 11:35:31AM +0100, Murray Cumming wrote: > > libgnomedbmm provides widgets for this kind of thing: > http://www.gtkmm.org/docs/libgnomedbmm-3.0/docs/index.html
These classes work fine for my smaller tables. The bigger ones create problemes. Therefore I have more questions: 1. With the SQL-Statement SELECT * FROM table LIMIT 100 the method Gnome::Gda::Query::set_sql_text of an instance throws the exception "Syntaxfehler nahe LIMIT" (syntax error near LIMIT). My mysql-commandline-client executes the statement. (How) can I use LIMIT? (I only want to use the provider MySQL.) 1b. Almost the same problem with REGEXP. 2. The grid for my table with approximately 300000 entries needs more than 10 minutes to be visible. (I have killed the programm after 10 minutes.) There must be a better way to show this table. http://www.gnome-db.org/DetailledLibgdaFeatures says "support for specifying how a SELECT query's result set will be accessed (random access or cursor based for large data sets), this feature however is not yet implemented in providers". I think this could help me. Does anyone know when this feature is implemented in the MySQL-provider? Regards, Holger _______________________________________________ gtkmm-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gtkmm-list
