> If you are going to do both of them, reverse the order.
>
> > Updatequery.InvalidateRows;
> > UpdateQuery.Refresh;
>
> Although, this seems like nonsense to me since a Refresh should do it all.
>
> If you can send me a sample case where it seems to need both, please send it
> to me. I'd like to take a look since I can think of no case where it should
> make a difference.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>

Jason, neither

UpdateQuery.Refresh;

or

Updatequery.InvalidateRows;
UpdateQuery.Refresh;

nor

UpdateQuery.Refresh;
Updatequery.InvalidateRows;

doesn't work properly.


The only way to reflect newly inserted rows is

TIB_Query.InvaludateSQL;
TIB_Query.Refresh;

or

TIB_Query.InvaludateSQL;
TIB_Query.RefreshKeys;

as Luiz advised.

But I dougbt. If

TIB_Query.InvaludateSQL;
TIB_Query.RefreshKeys;

is the same as Close-Open?

Regards, vicser.
mailto: vicser@...