Subject Re: [IBO] qry.Refresh v. InvalidateRows
Author Jason Wharton
Yes.

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


----- Original Message -----
From: "Tobias Giesen" <tobias_subscriber@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, September 10, 2001 6:25 AM
Subject: RE: [IBO] qry.Refresh v. InvalidateRows


> I asked:
> > When should I use a full Refresh, and when
> > should I just InvalidateRows?
>
> Since I got no replies so far I'm going to state what I think, and maybe
> someone will tell me if I'm right.
>
> With a SELECT * FROM X ORDER BY Z statement, use "InvalidateRows" when
only
> the contents of rows may have changed on the server, but not the number of
> rows, nor any primary key fields, or anything that may affect sorting.
>
> In all other cases, use "Refresh".
>
> Is that so?
>
> Cheers,
> Tobias