> If we have code on event OnPrepareSql of the TIBODataset bound a
> TDBGrid and doing some filtering of records depending on some
> conditions, calling in a TButton on click event code as:
> TIBOQuery.InvalidateSQL;
> TIBOQuery.Refresh;

> After this the TBGrid bound to dataset doesn't reflect the Refresh
> and gives AV when trying scroll it.

> With IBO native datasets all works very well.

Yes but the IBO native datasets have different timings etc to
TDataset. TDataset is out of our control. You may need to find an
alternative way of implementing your requirement.

Remember that IBO native is almost entirely dynamic, whereas TDataset
is much less so - even the IBO variation. I also know that there are
some synchronisation issues relating to the internal native dataset
and the external TDataset.

If you explain what exactly you are trying to achieve perhaps others
here can offer some suggestions. Perhaps you can use Filter
properties or parameters to achieve the desired effect.

--
Geoff Worboys - TeamIBO
Telesis Computing