Subject Re: [firebird-support] Re: Building query strings in stored procedures?
Author Martijn Tonies
> > 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!)

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