I'm getting to where I just may put it all in one file here soon...
Hint taken... I agree that as I familiarize myself with Delphi's new
capabilities I get annoyed myself.

Jason

----- Original Message -----
From: "Paul Hope" <paulhope@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, July 10, 2003 3:12 PM
Subject: Re: [IBO] SQLWhereItems to SQLWhere


> Jason
>
> > > Is there a function I can call to to turn a TStings containing 'where
> > items' in SQLWhereitems format into SQLWhere strings?
> >
> > Not that I can think of. It is done internally by IBO. I could possibly
> make
> > the code accessible somehow. Of course you can get in under the hood and
> do
> > that too if you want. <g> I'd merge in the changes for you.
> >
>
> I might get some time to have a look - trouble is I get so annoyed by the
> difficulty in navigating the source because of the way it is split up I
> usually give up :-|
>
>
> > > Why?
> > >
> > > Well - I often find I am calling a routine which will create a form,
set
> > up a query and display the results. The call includes various
parameters.
> > I want to construct the where clause using the parameters, but I would
> > rather not have to create form variables for each parameter so I can
pass
> > them through to the OnPrepareSQL event, or write the code to manage the
> > wheres and ands, when it may already exist.
> > >
> > > Might it be a useful future enhancement to make the SQLWhereItems
> persist
> > outside the OnPrepareSQL event?
> >
> > I suggest you use your own sub-class and have a property you use to
start
> > the OnSQLPrepare event by dumping its contents in there. This
effectively
> > would be the same thing.
> >
>
> Hmm - that's a crafty idea - will give that a try. Still think it would
be
> good idea to get SQLWhereItems to persist - it causes a lot of confusion
to
> new comers in its currently limited existence and would have other
benefits.
>
> Regards
> Paul
>
>
> > Jason