Hi to all,

do you know if it's possible to create a view with the order by clause setted runtime ? Can I use the ?paramter way like for where expression ? Example :

CREATE VIEW vwTest AS ;
SELECT field1, field2 FROM myTable ;
WHERE field1 LIKE ?param1 + "%" ;
ORDER BY ?orderkey

TIA