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

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Tobias Giesen" <tobias_subscriber@...>
To: <>
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
> 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