Inconsistent "Invalid Cursor State" Error, looking for insights
843835Feb 3 2003 — edited Feb 14 2003I have a jsp search page. For some queries, the jsp page works fine. Retrieve and output matching record normally. But for one query, I am matching a name with "name like 'G%'", it fails and give "Invalid Cursor State" Error after 8 matching records have been output.
I am confused by the pattern of this error. If anyone has experience with similar error, please shed some light on the situation. The situation is, after several tries to pin down the source, I am at a loss. The source of error seem to be too far deep into the ODBC and the Database Engine(Pervasive)I am using, I don't know of a tool to track the error.
Thanks in advance.