Is there a syntax where you can change the Order By clause based on Indicators?
Need to add an F8 "Sort By" to a screen with a Declared SQL Statement. Something like...
Or. is it something like:
Help! I can't get either to work...
Need to add an F8 "Sort By" to a screen with a Declared SQL Statement. Something like...
PHP Code:
Select * from ....
Where ...
Order By Case When (:inF8 = :cNo) Then Fld1, Fld2, Fld3
When (:inF8 = :cYes) Then Fld2, Fld3, Fld1
End;
PHP Code:
Select * from ....
Where ...
Order By Case When (:inF8 = :cNo) Then Fld1
When (:inF8 = :cYes) Then Fld2
End,
Case When (:inF8 = :cNo) Then Fld2
When (:inF8 = :cYes) Then Fld3
End,
Case When (:inF8 = :cNo) Then Fld3
When (:inF8 = :cYes) Then Fld1
End;
Comment