Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBGETPROP(ViewName,'view','ParameterList') problem
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01374622
Message ID:
01374629
Views:
11
>>Oooh I just found it in the menu. Thanks a lot.
>>
>>BTW, how are you doing?
>>
>>Alex
>
>Very well :-)
>
>MartinaJ

Glad you are doing well. Thanks for the help.

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
Previous
Reply
Map
View

Click here to load this message in the networking platform