So, if I understand correctly, you mean my Keylinks is not correct? Because
of my other problem, I checked it, and it was ok. Am I correct that the log
shows 2 fetches?

Bram van der Voet / A&V Automatisering



-----Oorspronkelijk bericht-----
Van: Jason Wharton [mailto:jwharton@...]
Verzonden: woensdag 20 maart 2002 19:16
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: Re[2]: [IBO] TIBOQuery.InvalidateRowNum


You are working with the buffer in what you are doing.

ERRCODE 100 simply means Eof.

When fetching an individual record IBO makes sure you are not actually
getting more than one record. Since IB/FB batches records together it won't
hit the network peeking ahead to see if only one row was indeed sent to the
client. If more than one does come back then I raise an exception alerting
you to the fact that your KeyLinks or JoinLinks are not setup correctly.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Bram van der Voet / A&V" <bram@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, March 20, 2002 8:13 AM
Subject: RE: Re[2]: [IBO] TIBOQuery.InvalidateRowNum


> Thanks, that one dit the trick. I thought I should always avoid recno in a
> C/S application :-)
>
> Bram van der Voet / A&V Automatisering
>



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/