U++ forum: Welcome to the forum

Re: SQL EXPR NOT WORKING ...OOPS YES IT IS [message #58179 is a reply to message #58178]

Wed, 09 March 2022 04:35

reign_of_terror
Messages: 6
Registered: October 2021

Promising Member

Hi guys-

I got it to work this time.

I think I had settings a little off. It was strange that some of the sql
worked and some didn't. That is why I got paranoid that something on
UPP end wasn't working. The thing that helped me was the logfile which
I never looked at until today. I think it was complaining about ambiguous
ID amongst whatever else.

I decided to give it another look after listening to some crickets.

Sorry all Sad

below works...

SQL * Select(ID.Of(EMPLOYEE), CNAME.Of(CONTACT), DEPTNO.Of(DEPT))
.From(EMPLOYEE)
.LeftJoin(CONTACT)
.On(ID.Of(EMPLOYEE) == fk_emp_id.Of(CONTACT))
.LeftJoin(DEPT)
.On(DEPTNO.Of(EMPLOYEE) == DEPTNO.Of(DEPT));
while(SQL.Fetch()){
//PromptOK("foo");
list.Add(SQL[ID],SQL[CNAME], SQL[DEPTNO]);
}

[Updated on: Wed, 09 March 2022 04:40]

Report message to a moderator