I am not sure what you mean. When opening View Designer on "Data" I see three options: Databases, Free Tables and Queries. I don't see a "Query"->"View Parameters..." option.

If I create a Query in plain "Queries" it doesn't allow creating an updateable query, which I need it to be.

Thanks again,

Alex



>Check "Query"->"View Parameters..." in "View Designer"
>
>MartinaJ
>
>>Thanks for the reponse Martina,
>>
>>I did generate the view with the view designer. How else can it be done?
>>
>>Alex
>>
>>>Hi Alexandro,
>>>
>>>Did you define the parameter in GUI (view designer)? This property is saved in view record in DBC and not generate from WHERE clause.
>>>
>>>MartinaJ
>>>
>>>>I created a parametrized local view in DBC()
>>>>
>>>>DBGETPROP('tur','view','SQL') returns the expected value, namely "SELECT pltur.* FROM pltur WHERE pltur.ccodtur = ?pccodtur"
>>>>
>>>>However, DBGETPROP('tur','view','ParameterList') returns an empty string. I expected a return value of "pccodtur, 'C'"
>>>>
>>>>Am I doing something wrong?
>>>>
>>>>TIA,
>>>>
>>>>Alex