Thanks Helen,

You have been very helpful on this. Unfortunately my program was started
with IBX and I am more familiar with IBX now, having considered a looming
deadline, perhaps I will take a look on IBO later.

Best wishes,
jr

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, August 01, 2001 8:50 PM
Subject: Re: [ib-support] Parameter in the Where clause


> At 08:34 PM 01-08-01 +0800, you wrote:
> >Hi Lester,
> >
> >In fact, what I want may be a bit too greedy, I am thinking of something
> >like this:
> >
> >select * from TABLE1 :WHEREPARAM
> >
> >where :WHEREPARAM might even be empty.
> >
> >Best wishes,
> >jr
>
>
> In IB Objects you can do this with ease but AFAIK there is no way to do it
with IBX or the BDE.
>
> In IBO you can have you IB_Query with SQL of
> SELECT whatever FROM aTable
>
> and then, in the OnPrepareSQL event, you can add whatever pieces you want
to be in the WHERE clause, e.g.
>
> with MyQuery do
> begin
> SQLWhereItems.Clear; // not usually necessary as the component does it
> SQLWhereItems.Add( '(' );
> SQLWhereItems.Add( 'MYCOL1 = 100' );
> SQLWhereItems.Add( 'OR' );
> SQLWhereItems.Add( 'MYCOL1 = 200' );
> SQLWhereItems.Add( ')' );
>
>
> and when parsed into the finalized SQL statement will end up as:
>
> WHERE .... < original criteria plus other system stuff >
> AND ( MYCOL1 = 100 OR MYCOL1 = 200 )
>
> etc. etc.
>
> Otherwise, without these benefits, you don't have any choice but to clear
and reparse the statement yourself whilst the dataset object is unprepared
and manufacture it by concatenating various strings, before preparing it
again.
>
> regards,
> Helen
>
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>