Re: -259 error using scroll cursor

> My program is an ESQL C program written on HP-UX and I have a > scroll cursor that is causing me problems. > > If I do a fetch current I get an error -259 in the sqlca.sqlcode > which is supposed to mean cursor not open. But if I do a fetch > next it works for part of the table. At some point near the end > of the table I get another -259 error. What gives? Have you got a commit or rollback work somewhere in the logic? This closes all cursors, unless you declare them WITH HOLD. Just a thought. akent@cix.compulink.co.uk (Andy Kent) ------------------------------------------------ Freelance Informix Database Specialist, Redland, Bristol, England