Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


CTLib BACKWARD cursor problem...

Posted on 2004-09-06
Medium Priority
Last Modified: 2006-11-17
    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?

Question by:small_potato
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 19

Expert Comment

ID: 11993770
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.


Expert Comment

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

download the latest open client
LVL 19

Expert Comment

ID: 12003086

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?


Accepted Solution

ChrisKing earned 1000 total points
ID: 12003173
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

Author Comment

ID: 12023722
Thanks for the solution!

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working from home is a dream for many people who aren’t happy about getting up early, going to the office, and spending long hours at work. There are lots of benefits of remote work for employees.
With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question