• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 450
  • Last Modified:

CTLib BACKWARD cursor problem...

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.
0
small_potato
Asked:
small_potato
  • 2
  • 2
1 Solution
 
grant300Commented:
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
0
 
ChrisKingCommented:
from memory this functionallity was added recently (Open Client 12.5.??? it think)

download the latest open client
0
 
grant300Commented:
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
0
 
ChrisKingCommented:
The version of the open client is independant to the version of the server (unless you need to use certain feature that is coded into both client and server, such as HA Failover)

Since the ability to scroll backward through a results set is coded completely in the client, upgrading the open client sdk should work
0
 
small_potatoAuthor Commented:
Thanks for the solution!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now