U++ forum: Welcome to the forum

Re: How to use aliases with SqlExp? [message #50327 is a reply to message #50324]

Fri, 21 September 2018 11:08

Patisab
Messages: 21
Registered: December 2015
Location: France

Promising Member

Good morning Mirek,

When i declare the alias T2 for table T1 as an other ID (with SqlId or with SQLID macro i have compiling errors. This

SqlId T2("T1");
SQL & Select(ID.Of(TABLE),COL1.Of(TABLE),COL2.Of(TABLE),COL1.Of(T2),COL2.Of(T2))
.From(TABLE)
.InnerJoin(TABLE).AsTable(T2).On(ID.Of(T2) == FATHER.Of(TABLE));

results

error: 'class Upp::SqlSet' has no member named 'On'

and that

SqlId T2("T1");
SQL & Select(ID.Of(TABLE),COL1.Of(TABLE),COL2.Of(TABLE),COL1.Of(T2),COL2.Of(T2))
.From(TABLE)
.InnerJoin(T2).On(ID.Of(T2) == FATHER.Of(TABLE));

results

note:   crosses initialization of 'Upp::SqlId T2'

Sorry, i probably not understand your explanations Crying or Very Sad

Best regards.

Report message to a moderator