[Firebird-devel] [ firebird-Bugs-1075224 ] Sorting in SP acordinglly to passed parameter

[SourceForge.net <no...@so...>]

Bugs item #1075224, was opened at 2004-11-29 13:05
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1075224&group_id=9028

Category: Core Engine
Group: Initial Bug
Status: Open
Resolution: None
Priority: 5
Submitted By: Andrzej (agjedrus)
Assigned to: Nobody/Anonymous (nobody)
Summary: Sorting in SP acordinglly to passed parameter

Initial Comment:
If procedure uses parameters responsible for sorting it 
doesnt work eg.

FOR 
SELECT t.x, t.y, t.z...
FROM Table t
ORDER BY :I_SORT
INTO 
DO SUSPEND

even then I use construction like
ORDER BY CASE :I_SORT WHEN 1 THEN r.x WHEN.... END 
it doesnt work, too

where I_SORT is integer that point to a column number.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1075224&group_id=9028