Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Open Cursor - SQL 502N

0 views
Skip to first unread message

Vince Marino

unread,
May 6, 1998, 3:00:00 AM5/6/98
to

I have a Delphi 3+ BDE 4.51 app that uses a DB2 NT database
with 4 TQuery's.

There are times when I get the SQL 502 error when trying
to open one of the queries.

SQL 502 says: "The cursor specified in an OPEN statement
is already open."

The conditions that induce the error seem to be related to
how many rows exist in the table to satisfy the query, with
the magic number at about 192.

I know that cursors are utilized when writing native DB2
apps, but the TQuery encapulates all that so I can't imagine
what the message means. Any help would be greatly appreciated.

Vince Marino
vma...@primenet.com

0 new messages