| Subject | Inconsistent Behavior - ibSQL vs. tQuery |
|---|---|
| Author | Jack Cane |
| Post date | 2014-06-06T02:19:31Z |
Query text is:
Best,
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
jwc