I'm very new at Firebird and am having a problem with the distributed example apifull.c. I have compiled it using Borland C++ 5.02 and it runs. It produces a simple program something like ISQL. When I run it, I can do expressions that do not require return parameters such as:

UPDATE mytable SET header_1 = 1 where header_1 = 7;

and things work. However, when I do a SELECT command that expects data returned, such as:

SELECT * FROM mytable;

nothing happens. I just get the SQL prompt. At that point, no matter what I enter, I get the message:
Synamic SQL Error
=SQL error code = -519
-The prepare statement identifies a prepare statement with an open cursor.

Within in the code, sqlda->sqld which is supposed to return the number of columns that will be returned is always zero.

Thanks.

Alan


[Non-text portions of this message have been removed]