I misunderstood the InvalidateSQL for the InvalidateRows method I think.
I suppose I need to pay better attention.

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

----- Original Message -----
From: "vicser" <vicser@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Saturday, May 25, 2002 5:26 AM
Subject: Re: [IBO] TIB_Query.RefreshKeys ignores updates


> > 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@...