<div>
Well, yes and no. &nbsp;If you need to walk the cursor backward the whole way, you can use DESC clause(s) on the ORDER BY..<br />
<br />
I am betting what you really want is a bi-directional cursor. &nbsp;Unfortunately, the only way to do that is to read the data from the cursor and into your own buffer as you go forward. &nbsp;When you need to go backwards, you walk back through the local buffer.<br />
<br />
It's not pretty but that's the way things were done before any of the databases engines supported bidirectional cursors.<br />
<br />
BIll
</div>


Well, yes and no.  If you need to walk the cursor backward the whole way, you can use DESC clause(s) on the ORDER BY..

I am betting what you really want is a bi-directional cursor.  Unfortunately, the only way to do that is to read the data from the cursor and into your own buffer as you go forward.  When you need to go backwards, you walk back through the local buffer.

It's not pretty but that's the way things were done before any of the databases engines supported bidirectional cursors.

BIll

<div>
from memory this functionallity was added recently (Open Client 12.5.??? it think)<br />
<br />
download the latest open client
</div>


from memory this functionallity was added recently (Open Client 12.5.??? it think)

download the latest open client

<div>
ChrisKing,<br />
<br />
IQ is a couple of point revs behind ASE and CTlib. &nbsp; Is Open Client 12.5.2 backword compatible with IQ 12.5 &nbsp;and still retain the new functionality?<br />
<br />
Bill
</div>


ChrisKing,

IQ is a couple of point revs behind ASE and CTlib.   Is Open Client 12.5.2 backword compatible with IQ 12.5  and still retain the new functionality?

Bill

<div>
<div class="content wysiwyg-content">
hi!<br />
&nbsp; &nbsp; I am using CTLib to connect the Sybase IQ Server. After executing the SQL statement, I retrieve the data by api cursor. <br />
&nbsp; &nbsp; The problem is, the header file(cspublic.h) commended that it does not support the backward cursor...any solution about that? <br />
<br />
thanks.
</div>
</div>


hi!
    I am using CTLib to connect the Sybase IQ Server. After executing the SQL statement, I retrieve the data by api cursor. 
    The problem is, the header file(cspublic.h) commended that it does not support the backward cursor...any solution about that? 

thanks.

CTLib BACKWARD cursor problem...

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.