At 09:26 AM 19/03/2012, Newbie wrote: >How to best implement ORDER BY of a query when the field by which to >order, is given as stored procedure input parameter?
It is not possible to that directly, as ORDER BY is a structural element that is pre-compiled. >for example a typical product list where could be ordered by Name, Price >etc fields depending on what user clicks. > >I tried to include it into query: > >for >select f1, f2 from t1 >order by :order_by_field >into :p1, :p2 > >I am not getting any errors, but it doesn't order the list. how to do it >better? Use EXECUTE STATEMENT. Look up the Language Reference Update document for your version of Firebird to see how this is achieved. You should find it in the ../doc/ subdirectory of your installation; if not, you can download it from the Firebird website documentation area. ./heLen
