On 9/17/07, Murray Cumming <[EMAIL PROTECTED]> wrote: > On Thu, 2007-06-07 at 08:58 +0200, Murray Cumming wrote: > > On Wed, 2007-06-06 at 23:31 +0200, Vivien Malerba wrote: > > > > If you want a data model which is based on cursors only (no random > > > > access then), you need to set a parameter named "ITER_MODEL_ONLY" of > > > > type boolean to TRUE which is given to the > > > > gda_connection_execute_command() family functions as the @params > > > > attribute. The same is true for the gda_query_execute() function. > > > > > > > > This function then in the end calls > > > > gda_server_provider_execute_command() which is passed the same @params > > > > list of parameters. Each DBMS provider is then free to treat that > > > > parameter or ignore it (as is currently the case). If a provider > > > > chooses to honor that request, then the associated data model needs to > > > > be improved to support cursor based nabigation (for example for > > > > PostgreSQL, the GdaPostgresRecordset object needs to be modified). > > > > > > > > > > It's now in SVN trunk (won't be in 3.0.2 but in 3.2.x). I've also > > > added an "ITER_CHUNCK_SIZE" parameter which, if specified, instructs > > > the provider to fetch SIZE rows at once instead of only one when the > > > iterator moves to avoid performances problem related to many data > > > fetches from the DB. > > > > Many thanks. This sounds perfect. I'll have time to try it in about 2 > > weeks time. Thanks, again. > > I'm trying this now in Glom, but I get this strange error > " > DECLARE gda_1190032034_895812_0 SCROLL CURSOR WITH HOLD FOR SELECT > "artists"."artist_id", "artists"."name", "artists"."description", > "artists"."comments", "artists"."artist_id" FROM "artists" ORDER BY > "artists"."artist_id" ASC > (unknown number of rows) > "
This is just a connection event of type GDA_CONNECTION_EVENT_NOTICE, you can ignore it (I think if you compile libgda withouth the debug flags, it will go away). Cheers, Vivien _______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
