1

Topic: SQLVar TableAlias

There is a request, in which one table  twice. Let will be type such

SELECT
mod1. "NAME";
mod2. "NAME"
FROM
moduls mod1;
moduls mod2

The question - whether can be received somehow  tables for two fields? Tables can be received through

SqlVar. RelName

but to this field RelName it is identical. Whether it is possible to take a bite somehow  tables
Server Interbase 2009/XE3
Yours faithfully, Vasilisk

2

Re: SQLVar TableAlias

_Vasilisk _;
Absolutely not clearly. Whence to take a bite?  work only in requests.

3

Re: SQLVar TableAlias

KreatorXXI wrote:

. Whence to take a bite?

From prepared

IBSQL1.SQL.Text: =.......
IBSQL1.Prepare;
ShowMessage (IBSQL1.Fields [0].SqlVar. RelName);

4

Re: SQLVar TableAlias

_Vasilisk _;
Whether is easier in the request normal  to fields to give?

5

Re: SQLVar TableAlias

[quote = _ Vasilisk _] but to this field RelName it is identical. Whether it is possible to take a bite somehow  tables

Sqlvar. AliasName?.