Hi Martin,

>
>What I see is that I assumed that once dettached, the cursor was in fact indepent from the underlying recordset. I can workaround this as I can close everything AFTER generating the XML... in this situation.
>
>Any comments or opinions appreciated.
>

Your assumptions were wrong. Once detached, the cursor is independent from the CursorAdapter object, but not from its data source. You can use CURSORGETPROP("ADORecordset") to get the Recordset associated with the cursor even if it is detached from the CursorAdapter object.

The error is reported because cursor is not fetched completely when connection is closed, more specifically, it is reported during an attempt to fetch more records. To avoid this problem, execute GO BOTTOM before closing connection or use oCA.FetchSize = -1 when you call CursorFill.

Thanks,
Aleksey.