I found the source of the problem, the field CODE in the table CLIENTS is
of type Char(8) while in table Operators is Char(4).
I converted the CODE fields to Varchar(8) and Varchar(4) and everything
works fine now

Thank you

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Saturday, August 28, 2004 3:36 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] statement Union in a TIBO_Query


At 06:27 PM 27/08/2004 +0200, you wrote:

>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?

The exception is coming from the db engine, not from IBO, i.e. the DB
engine doesn't like your query syntax.

Questions (for testing purposes):

1. Which DB engine are you using?
2. Are you using TIB_Query or TIBOQuery?
3. What is the metadata of the two columns in each table, respectively?
4. What statement are you seeing in the SQL monitor?
5. What version of IBO?

Helen

>

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !


Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
----
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

b.. To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




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