At 03:23 PM 11/09/2003 +1000, you wrote:

>I have an annoying "unknown cursor" exception which pops up from time to
>time. We've discussed this before and I know it's something to do with a
>dataset (and datasource) closing before a reliant dataset closes but I don't
>seem to be able to debug it. It happens when I call
>IB_Connection1.DefaultTransaction.Refresh(true);
>but of course, there's a lot going on here and there are a lot of datasets
>open and being committed...
>Does anyone have a good way of debugging this? (I mean apart from sitting
>for the next 6 hours on the F7 key?

Assuming this is an eib_isc exception -- first place I would want to look
is at any stored proc you are executing inside that transaction --- and
debug the logic of that -- look for anywhere that you have a procedure that
mistakenly assumes there will be a non-null value in a parameter or local
variable...

Helen

>thanks
>Alan
>
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/