Subject Re: Inconsistent Behavior - ibSQL vs. tQuery - PLEASE IGNORE PENDING FURTHER...
Author Jack Cane
Post date 2014-06-06T03:24:30Z
Should add that the sought-for row in tableTWO actually exists, because attempts to insert a new row, via tibDsql, fail.

But...this just in...BELIEVE I have found the cause of this...please ignore this thread unless you hear further from me.
Best,
jwc

On Jun 5, 2014, at 10:19 PM, Jack Cane <jwcane@...> wrote:

Query text is:

SELECT pkOne
FROM tableONE
LEFT JOIN tableTWO 
ON fkONE=pkONE
WHERE colTwofmOne = 'someValue'

When I run this from the IboSqL interface, the result is correct, i.e., a record is returned when the 'where' condition is satisfied.

However,  the same query text against the same table row, using Delphi with tIboQuery, returns 0 records.

Any insights, ideas of what other IBO objects might be better, would be appreciated

Best,
jwc