Helen,

> What did you discover on page 113 of the API Guide? Anything similar to
> this?

Yes, it is the same. That is the explanation of how to identify the type of
an unknown statement. So far, so good. But what about the other constants
listet in ibase.h? I see the following (taken from FB RC2, only my printed
docs are older)

/*************************/
/* SQL information items */
/*************************/

#define isc_info_sql_select 4
#define isc_info_sql_bind 5
#define isc_info_sql_num_variables 6
#define isc_info_sql_describe_vars 7
#define isc_info_sql_describe_end 8
#define isc_info_sql_sqlda_seq 9
#define isc_info_sql_message_seq 10
#define isc_info_sql_type 11
#define isc_info_sql_sub_type 12
#define isc_info_sql_scale 13
#define isc_info_sql_length 14
#define isc_info_sql_null_ind 15
#define isc_info_sql_field 16
#define isc_info_sql_relation 17
#define isc_info_sql_owner 18
#define isc_info_sql_alias 19
#define isc_info_sql_sqlda_start 20
#define isc_info_sql_stmt_type 21
#define isc_info_sql_get_plan 22
#define isc_info_sql_records 23
#define isc_info_sql_batch_fetch 24

BTW, I found isc_info_sql_records during my search for a API functionality to
find out the number of rows returned from a query without fetching all rows
and thought it would be great to get some more infos about all the constants
above.

> By the way, it's recommended that you mention which database and version
> you are using when you first raise a support question...

Sorry, you are right. As mentioned above, it is Firebird RC2.


Thanks for your patience

Uwe