Subject Re: [IBO] "Cursor alread exists" error
Author Helen Borrie
At 08:54 PM 24/03/2004 -0600, you wrote:
>I'm running a simple query using ib_sql:
>
> select *
> from people
>
>and I get the following error:
>
>ISC ERROR CODE:335544569
>
>ISC ERROR MESSAGE:
>Dynamic SQL Error
>SQL error code = -502
>Declared cursor already exists
>
>STATEMENT:
>TIB_Query: "<TApplication>.frmSQL.frmQuery.qrQuery."
>
>I've rebooted, etc, and still get this error. Any ideas what the problem
>might be?

1. You'll get an error if you try to run a multi-row query in the DSQL
window of IB_SQL. (Use the Cursor tab or a Query Form). The correct
message should be "Multiple rows in a singleton select" or similar.

2. You are getting the wrong message back from the client for your
error. That indicates that you're using the wrong version of the client
library and message files.

What have you done about installing a Fb 1.5 client?

Helen