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,
Jason Wharton

From: []
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!