>
> FOR EXECUTE STATEMENT <statement>
> DO ...
>
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle &

MS SQL

> Server
> Upscene Productions
> http://www.upscene.com

Thanks Martijn, I think i've got this now (I've manage to do an
example or two with query strings as inputs).

Helen's book is pretty off putting about using this approach, however
(page 594). She mentions that this will be slow, and this agrees with
comments (from Tim) earlier in this thread.

I haven't yet done any tests on fully loaded database, but if there is
no appreciable improvement (speed & ease versus ordinary SQL select
queries straight from web application) in doing things this way,
perhaps there is no point after all! As mentioned previously, using an
SP with pre-constructed, layered IF NULL statements etc.. I notice
that the SP is roughly 3 times quicker than a straight SQL select query.

Will

Will