>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

Hello Renato,

Just go thoough this.

SET SAFE OFF
lcorder = 'myfield'

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

Basically my idea is to create the runtime.

HTH

Bye
Jayesh