Subject RE: [IBO] statement Union in a TIBO_Query
Author Vahan Yoghoudjian
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
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
>and I'm getting the following Error Message:
>ISC ERROR CODE: 335544569
>Dynamic SQL error code = -104
>Invalid Command
>Data Type Unkown
>TIBOInternalDataset: "DataModuleForm.DModule.QrSearch.
>The same statement works fine in a TQuery, does TIBO_Query support the
>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?


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

Yahoo! Groups Sponsor

Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

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

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