Subject Re: [firebird-support] order by using parameter of stored procedure
Author Tomasz Tyrakowski
> How to best implement ORDER BY of a query when the field by which to
> order, is given as stored procedure input parameter?

If the data set returned by the procedure is not very large, return all
relevant fields from the procedure and use order by in the query
selecting from the procedure (it won't use indices, so it's only
suitable for reasonably small number of records). Otherwise, I'd opt for
EXECUTE STATEMENT, as Helen suggested.


__--== Tomasz Tyrakowski ==--__
__--== SOL-SYSTEM ==--__
__--== ==--__