-259 error using scroll cursor
Posted in 1995
Topics: Error Codes & Troubleshooting, Connectivity: ESQL/C, 4GL & Embedded SQL, Platform-Specific Issues
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? This error only occurs when I am selecting the whole table whether by not including the where clause or using a where clause that is true for all rows in the table. I can do queries on every imaginable set other than the entire thing and the query routines work fine. I looked for string overwrites b/c I thought I was hammering the sqlca struct but I haven't found any evidence of that. Any ideas? Thanks for Reading This Message. Rob Schulz Any ideas? Thanks for Reading This Message. Rob Schulz I looked for string overwrites b/c I thought I was hammering the sqlca struct but I haven't found any evidence of that. Any ideas? Thanks for Reading This Message. Rob Schulz