From: Grant M. <gmc...@in...> - 2005-07-06 23:27:39
|
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. |