>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
- Jayesh