I have a situation with an IB_Query in which I am changing a parameter.
RefeshOnParamChange is true. The query has it's key source and keylinks set
to another query. Problem is there are instances in which I get a "multiple
rows in singleton select" error. The error I believe is caused from having
an empty result set. Not sure why I get the error I am getting.

I am having trouble figuring out a way to trap for this error. I have tried
manually closing the dataset with RefreshOnParam set to false, then change
parameters and using a Try...Except on the open method, but the error does
not get raised in the open method.

Anyone got some insight on this?

Thanks,
Paul