Hello there,

I'm using the function TIB_Query.InvalidateRowNum to update the
query's buffer if the underlying data has changed.
The select in the query looks like "select * from function_foo()". The
problem is this: When the data has changed in such a way that
function_foo does not include the old dataset anymore, the dataset is
removed from the list. This behavior is, however, very bad in the my
situation.

I have currently no good ideas how to prevent this. The only one I can
come up with is checking whether the current dataset is returned by
the function before calling
InvalidateRowNum and skip it if it does not exist. That way, the data
is not refreshed, though - but it's at least better than the whole
dataset disappearing.

The optimal solution would be a separate select-statement that is used
for invalidation, but I guess this is not possible, is it?

Regards,
Daniel Albuschat

--
eat(this); // delicious suicide