|Subject||RE: SV: [IBO] IBOQuery : Filtering problem with left join|
|Author||IBO Support List|
Sometimes, depending on your query, you should put such things in the JoinLinks property if the where clause condition is expected to be a part of the JOIN clause.
You will want to take a look at what IBO actually sends to the server using the SQL trace capabilities. Your query may appear to work but it may not.
I also recommend always trying to use a valid KeyLinks entry for your query. Removing it could make a problem that does exist more difficult to detect.
Hope this helps,
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Tuesday, December 16, 2014 8:09 AM
Subject: Re: SV: [IBO] IBOQuery : Filtering problem with left join
Thanks so much for your suggestion. I did not know this syntax fo using tmp(). I'll give it a try.
I've just tried something that did solve the problem. I've set KeyLinks = TCCLIENTS.CLIENT and KeyLinksAutoDefine = false. It seems to have solved the problem. It was very odd, that data would be lost when the where clause was modified..
I will, though, try your solution too!