Subject Re: [IBO] KeyLinks
Author Matt Nielsen
The InvalidateBookmark doesn't call that event unfourtunatly.
--- In, Markus Ostenried <chef_007@g...>
> At 22:14 Friday, 06.06.2003 +0000, you wrote:
> >Is there a way to manually add the WHERE clause to the SQL
> >that InvalidateBookmark will use at the last posible moment via an
> >event or other? I want to customize the WHERE clause to be more
> >just the KeyLinks = KeyFields.Value.
> Hi,
> have a look at the help for the OnPrepareSQL event. Maybe that's
> you're looking for. Usage is quite simple:
> In the event add your where criteria like
> 'FIELD = ''VALUE''' ); If you want the where items to be updated
just call
> IB_Query1.InvalidateSQL;
> IB_Query1.Refresh;
> HTH,
> Markus