| Subject | RE: SV: [IBO] IBOQuery : Filtering problem with left join |
|---|---|
| Author | IBO Support List |
| Post date | 2014-12-18T22:56:23Z |
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: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Tuesday, December 16, 2014 8:09 AM
To: IBObjects@yahoogroups.com
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!