Dimitry,

Thanks for the reply. I follow your lead to read up page 52 on
"Requesting information about an attachment" and wrote the following
code fragment:

char type_item[] = {isc_info_sql_records};
char infoBuf[40];
isc_dsql_sql_info(status, &hStmt, sizeof(type_item), type_item,
sizeof(infoBuf), infoBuf)

and got this:

Hex 0 1 2 3 4 5 6 7 8 9 A B C D E F
-------- ------------------- -------------------
0 171d 0 f 4 0 1 0 0 0 10 4 0 0 0 0
10 0 d 4 0 1 0 0 0 e 4 0 0 0 0 0 1
20 1cc cccc cccc cccc

The thing is itemType 0x17 (or 23) is not defined in ibase.h, which has
#define isc_info_req_update_count 15
decimal 15 is 0x0F

As indicated, offset 32, 0x20, has value of 0x01, which is isc_info_end.

So this is something else and is not what I expected. Again, the
prepared stmt "update Staff set salary = ? where id = ?" had been
executed correctly and there is no error in the execution nor the
isc_dsql_sql_info() call.

Any idea?

jml