ok.

What of worst can happen wusing SQLWhere directly?
Im accostumated to do it. And, until now, i dont get any problems...
(im using TIBOQuery)

Thanks,

Guto

On 11/1/05, Helen Borrie <helebor@...> wrote:
> At 10:50 AM 1/11/2005 -0200, you wrote:
> >How SQLWhere method will behavior if my SQL have a UNION statement?
>
> You must never use SQLWhere directly. It is used internally by IBO.
>
> With UNION sets you cannot use SQLWhereItems, since the search clauses for
> the contributing sets are separate and IBO's parser has no way to tell
> which individual SELECT an SQLWhereItem should apply to.
>
> If you need this capability (AND you are using Firebird 1.5!!) you can
> create a view from the union and apply SQLWhereItems to a SELECT statement
> on that view. Don't make very large or complex unions if you are going to
> do this, as the selection process will be very slow.
>
> 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 Links
>
>
>
>
>
>
>


--
Guto