Subject | Re: [IBO] qry.Refresh v. InvalidateRows |
---|---|
Author | Jason Wharton |
Post date | 2001-09-10T15:26:34Z |
Yes.
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
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