Re: [Firebird-devel] Retrieving relation alias

2014-12-17 Thread Rudolf Grauberger
Hey guys,thanks for the information and your support. Using the implementation of Java (postet byMark Rotteveel), the source code from the Firebird server (https://searchcode.com/codesearch/view/25432247/)andwith support of mycolleagues at work, I could understand the process and can now also

Re: [Firebird-devel] Retrieving relation alias

2014-12-16 Thread Vlad Khorsun
16.12.2014 11:13, Mark Rotteveel wrote: > On Tue, 16 Dec 2014 11:03:39 +0200, Vlad Khorsun > wrote: >> 16.12.2014 10:27, Rudolf Grauberger wrote: >>> I would like to read the table aliases, >> >> After call of isc_dsql_prepare() you'll have XSQLDA structure filled >> with all >> info, incl

Re: [Firebird-devel] Retrieving relation alias

2014-12-16 Thread Mark Rotteveel
On Tue, 16 Dec 2014 11:03:39 +0200, Vlad Khorsun wrote: > 16.12.2014 10:27, Rudolf Grauberger wrote: >> I would like to read the table aliases, > >After call of isc_dsql_prepare() you'll have XSQLDA structure filled >with all > info, including known relation aliases. Read IB6 "API Guide",

Re: [Firebird-devel] Retrieving relation alias

2014-12-16 Thread Vlad Khorsun
16.12.2014 10:27, Rudolf Grauberger wrote: > I would like to read the table aliases, After call of isc_dsql_prepare() you'll have XSQLDA structure filled with all info, including known relation aliases. Read IB6 "API Guide", chapter "Working with Dynamic SQL". Guide is available here:

Re: [Firebird-devel] Retrieving relation alias

2014-12-16 Thread Mark Rotteveel
On Tue, 16 Dec 2014 08:27:33 GMT, "Rudolf Grauberger" wrote: > I would like to read the table aliases, here I found out that I need to > call the function isc_dsql_sql_info () with the parameter > isc_info_sql_relation_alias. > > However, I have not figured out which parameters I need to call thi

[Firebird-devel] Retrieving relation alias

2014-12-16 Thread Rudolf Grauberger
I would like to read the table aliases, here I found out that I need to call the function isc_dsql_sql_info () with the parameter isc_info_sql_relation_alias. However, I have not figured out which parameters I need to call this function and how do I read the information. I already have at goog

Re: [Firebird-devel] Retrieving relation alias

2012-04-09 Thread mark
> 09.04.2012 20:22, Dimitry Sibiryakov wrote: >> >> Isn't aliasname field of XSQLVAR for the relation alias name?.. > > It's the field alias, IIRC. As far as I know it does indeed contain the field alias, but there is a comment in the code that says it is for the relation's alias name. Mark ---

Re: [Firebird-devel] Retrieving relation alias

2012-04-09 Thread Dmitry Yemanov
09.04.2012 20:22, Dimitry Sibiryakov wrote: > > Isn't aliasname field of XSQLVAR for the relation alias name?.. It's the field alias, IIRC. Dmitry -- For Developers, A Lot Can Happen In A Second. Boundary is the first t

Re: [Firebird-devel] Retrieving relation alias

2012-04-09 Thread Dimitry Sibiryakov
09.04.2012 18:18, Dmitry Yemanov wrote: > The relation alias is a Firebird extension not supported by XSQLDA, so > you have to retrieve it manually via isc_dsql_sql_info(). Isn't aliasname field of XSQLVAR for the relation alias name?.. -- SY, SD. -

Re: [Firebird-devel] Retrieving relation alias

2012-04-09 Thread Dmitry Yemanov
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_

[Firebird-devel] Retrieving relation alias

2012-04-09 Thread Mark Rotteveel
In Jaybird the java implementation of the remote protocol is capable of retrieving the relation alias in a prepare, however with the native (and embedded) implementation this fails (or at least: the relation alias is not returned). In the Java code the isc_dsql_prepare requests the following in