Re: [gnome-db] libgda cursor support

["Vivien Malerba" <vmalerba gmail com>]

On 9/17/07, Murray Cumming <murrayc murrayc com> wrote:
>
> On Mon, 2007-09-17 at 16:31 +0200, Vivien Malerba wrote:
> > On 9/17/07, Murray Cumming <murrayc murrayc com> wrote:
> > >
> > > On Mon, 2007-09-17 at 14:57 +0200, Vivien Malerba wrote:
> > > > On 9/17/07, Murray Cumming <murrayc murrayc com> wrote:
> > > > > 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).
> > >
> > > Ah. I'll have to add some hacks in the bindings to stop them from
> > > throwing exceptions for these. It is rather strange that you are setting
> > > a GError that is not an error.
> >
> > It should not be set using a GError, it's a GdaConnectionEvent. Can
> > you tell me where in the code it sets the error?
>
> Sorry, you are right. It seems to be a rows count < 0 that is causing
> Glom to read out the last connection events to explain the error. The
> attached test case shows that the rows count is -1 when we use the
> ITER_MODEL_ONLY parameter.

This means that the total number of rows of the returned data model is
not yet known, you need to iterate over it to reach the end, at which
time the total number of rows will be known and
gda_data_model_get_n_rows() will return something >= 0.

Vivien