ct_send error

Grant McDonald <[email protected]> Wed, 6 Jul 2005 16:27:58 +1000
Newsgroups gmane.comp.python.sybase
Message-ID <61DA7719C45FD31185280008C733EF6E04AC4E25@XCHANGE>
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.

_______________________________________________
Python-sybase mailing list
[email protected]
https://www.object-craft.com.au/cgi-bin/mailman/listinfo/python-sybase