Hi,
I received the following error when trying to do an update:
ct_send(): user api layer: external error: This routine cannot be called
because another command structure has results pending.
This update occurs after a select using a Cursor object which I haven't yet
closed. If I close the select cursor object prior to trying to do the update
I no longer get this problem. I found reference to this problem in a Sybase
manual which mentioned that ct_results needed to return a value before the
results set was considered processed. Do I need to call .return_status on
the select cursor before I can use another cursor to do an update? Or do I
have to close the select cursor before doing any updates?
Regards,
Grant M.
P.S. both the select and the update were to the same table.
|
