----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Saturday, July 12, 2003 5:50 AM
Subject: Re: [IBO] SQLWhereItems to SQLWhere


> I'm getting to where I just may put it all in one file here soon...

Great news ;-)

Paul

> 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
>
>
>
>
___________________________________________________________________________
> 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 !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>