>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
This is not possible. The interesting thing is, it _IS_ possible if you enter a numeric field position value for orderkey in the parameter window. But if you try to assign the variable a value before using the view you will get an error "Column 'orderkey' is not found.
Best thing is do as Bruce suggested, and just index the view at run-time.
Erik Moore
Clientelligence