Subject Re: Building query strings in stored procedures?
Author Adam
--- In firebird-support@yahoogroups.com, "willogibbo"
<willogibbo@y...> wrote:
>
> >
> > Thanks Tim and Ann for your thoughts.
> >
> > I don't quite understand how to make EXECUTE work for me. Perhaps you
> > could mention some kind of basic example to get me going.
> >
> ...in post number 60,584 I've just seen an example of an SQL statement
> 'on the fly' and using 'EXECUTE STATEMENT' on it , so I have enough to
> get me going ... Please disregard my previous reply (although if there
> is a solution to using a string as an input for a FOR SELECT...DO
> stored procedure I'd love to understand it!)
>
> Will

I think the suggestion was to have the PHP generate the select
statement then use the execute syntax to run it inside the for ...
into .... do. Check the FB 1.5 release notes, there is an example in
there of how to use it.

Adam