Hello,

Had a problem switching from Firebird 1.5 to 2.1.

I had the following query in a TIB_Query which has worked
fine for years.


select SOURCE, PART, WAREHOUSE, CONDITION, NOTESFLAG, PHOTOFLAG
from spviewpartsWithUnknown(:Part, 'R', :Alt, 'F') a
left join PARTPRICE on partprice.pp_part = spViewPartsWithUnknown.part


When I installed the new version of Firebird it started throwing
an exception :


"Column unknown SPVIEWPARTSWITHUNKNOW.PART At line 7, column 67"


This only happened in Ibobjects, not in IB Manager. So I upgraded
the IBObjects to the newest version and it continued to happen.
So I took a closer look at the query and found that when I removed
the "SPVIEWPARTSWITHUNKNOW." (as below) from the left join the
problem was solved.


select SOURCE, PART, WAREHOUSE, CONDITION, NOTESFLAG, PHOTOFLAG
from spviewpartsWithUnknown(:Part, 'R', :Alt, 'F') a
left join PARTPRICE on partprice.pp_part = part


This leads me to believe that something changed in the interaction between
IBObjects and Firebird during the move between versions 1.5 and 2.1.

Comments please

Thanks
Michael Horne