09.04.2012 19:26, Mark Rotteveel wrote:
> I notice in /jrd/why.cpp (2.5 branch) that a similar named array does
> not have the isc_info_sql_relation_alias entry:
>
> static const SCHAR sql_prepare_info2[] =
> {
> isc_info_sql_stmt_type,
>
> // describe_select_info
> isc_info_sql_select,
> isc_info_sql_describe_vars,
> isc_info_sql_sqlda_seq,
> isc_info_sql_type,
> isc_info_sql_sub_type,
> isc_info_sql_scale,
> isc_info_sql_length,
> isc_info_sql_field,
> isc_info_sql_relation,
> isc_info_sql_owner,
> isc_info_sql_alias,
> isc_info_sql_describe_end,
>
> // describe_bind_info
> <removed describe_bind_info part>
> };
>
> Is this a bug or limitation in the implementation of the client, or do I
> need to do something extra in Jaybird to get the native library to
> retrieve the relational alias information as part of the prepare?
As far as I remember, the client retrieves only the minimal subset of
items that can be represented inside XSQLVARs.
The relation alias is a Firebird extension not supported by XSQLDA, so
you have to retrieve it manually via isc_dsql_sql_info().
Dmitry
------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
