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/
>
>