Hi Folks:

Olivier told me this looks like an issue with Firebird.

Developing on Win2K, MSVC6, IBPP 2.3.5.0, Firebird 1.5.2.4731
embedded server.

I'm using my first SQL UNION statement, perhaps I've got it
wrong, but IBPP's execute is reporting the following problem:

----------------

*** IBPP::Exception ***
Context: Statement::Execute( SELECT
*
FROM
PLAYER_TABLE_01
WHERE
(
PLAYER_ID IN
(
SELECT
OWNER_PLAYER_ID
FROM
INTEREST_TABLE_01
WHERE
(
(
INTEREST_NAME = 'Tennis'
)
)
)
)
UNION
SELECT
*
FROM
PLAYER_TABLE_01
WHERE
(
PLAYER_ID IN
(
SELECT
OWNER_PLAYER_ID
FROM
INTEREST_TABLE_01
WHERE
(
(
INTEREST_NAME = 'Aerobics'
)

OR
(
INTEREST_NAME = 'Gymnastics'
)
)
)
)
)
Message: isc_dsql_execute failed

SQL Message : -413
Overflow occurred during data type conversion.

Engine Code : 335544334
Engine Message :
conversion error from string "BLOB"

---------------

This is dynamic SQL, and needless to say, this is a
simplified query. I don't need a union for this
example, but I believe one is needed when the subquery
for the first clause of the UNION becomes more
complicated.

I'm not an SQL expert, do you see a fault in this
query?

PLAYER_TABLE_01 has an array, but no blob, and
INTEREST_TABLE_01 has neither array or blob.

I've queried records from both these tables with no
problems.

Suggestions?

Thanks
Larry