Re: [gnome-db] libgda cursor support

[Murray Cumming <murrayc murrayc com>]

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)
"


-- 
murrayc murrayc com
www.murrayc.com
www.openismus.com