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

Hi Erik,

It may have some errors but my idea is to create view runtime.

Bye
Jayesh