<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2657.73">
<TITLE>ct_send error</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Hi,</FONT>
</P>
<P><FONT SIZE=2>I received the following error when trying to do an update:</FONT>
</P>
<P><FONT SIZE=2>ct_send(): user api layer: external error: This routine cannot be called because another command structure has results pending.</FONT></P>
<P><FONT SIZE=2>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?</FONT></P>
<P><FONT SIZE=2>Regards,</FONT>
</P>
<P><FONT SIZE=2>Grant M.</FONT>
</P>
<P><FONT SIZE=2>P.S. both the select and the update were to the same table.</FONT>
</P>
</BODY>
<!--[object_id=#infocomp.com#]--><P><FONT face=Arial color=#808080 size=1>Important notice: This message is intended for the individual(s) and entity(s) addressed. The information contained in this transmission and any attached, may be confidential and may also be the subject of legal privilege, public interest immunity or legal professional privilege. Any review, retransmission, dissemination or other use of, taking of any action in reliance upon this information by person or entities other than the recipient is prohibited and requires authorization from the sender. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person) you may not copy or deliver this message to anyone. In such cases you should destroy this message and kindly notify the sender by reply email. </FONT></P>
<P><FONT face=Arial color=#808080 size=1>WARNING: Although Infocomp has taken reasonable precautions so that no viruses are present in this e-mail, the company cannot accept responsibility for any loss or damage arising from the use of e-mail attachments.</FONT></P></HTML>