[DUG]: Use of UNION in IBO

[Mike Osborne]

Title: Message

I have a TIBOQuery that uses UNION.   The SQL runs fine in IB Console, and in the TIBOQuery SQL Editor with hardcoded values. In the program the query is the detail in a master/detail relationship.   When I run in a program it seems to be OK if there are no rows returned in the result set, but if there are then I get    SQL error code = -104 Invalid command count of column list and variable list do not match   Any ideas what may cause this? Does UNION work n IBO?   TIA Mike