Subject | [IBO] SQLWhereItems to SQLWhere |
---|---|
Author | Paul Hope |
Post date | 2003-07-10T10:47:01Z |
Is there a function I can call to to turn a TStings containing 'where items' in SQLWhereitems format into SQLWhere strings?
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?
Regards
Paul
[Non-text portions of this message have been removed]
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?
Regards
Paul
[Non-text portions of this message have been removed]