I'm using a TIBO_Query to run the following SQL statement

SELECT CODE,NAME FROM CLIENTS

UNION

SELECT CODE,NAME FROM OPERATORS

and I'm getting the following Error Message:

----------------------------------------------------------------------------
---
ISC ERROR CODE: 335544569
ISC ERROR MESSAGE:
Dynamic SQL error code = -104
Invalid Command
Data Type Unkown

STATEMENT:
TIBOInternalDataset: "DataModuleForm.DModule.QrSearch.
<TIBOInternalDataSet>."
----------------------------------------------------------------------------
----

The same statement works fine in a TQuery, does TIBO_Query support the UNION
statement or I'm doing something wrong?

Thank you in advance


Vahan Yoghoudjian
Profiles



[Non-text portions of this message have been removed]