[python-sybase] ct_send error

[Grant McDonald]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.object-craft.com.au/pipermail/python-sybase/attachments/20050706/f682f17f/attachment.htm