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

If you try this, you will find that it creates an error.