I gave you the other option of DBGetProp('myview', 'view', 'sql') which returns the SQL query used to create the view. You can then parse it to find all the filter clauses in the WHERE.

>Hi, Mark.
>
>Actually, DBGETPROP() seems to return a value only if the view parameters have been defined in the "View Parameters" dialog from within the View Designer.
>
>As for Stonefield ... well, this will be a generic class that can be dropped into any application. What do I do if Stonefield wasn't used in the application?
>
>I need a sure-fire way to get this information without 3rd-Party utilities.
>
>Thanks for the help.
>
>-Bri.
>
>
>>Offhand, you could DBGETPROP() the SQL property and create a function to parse that string to give the parameter list.
>>
>>You could also use a tool like Stonefield to extend the properties for your database. You can add your own properties and values that you can retrieve with SDT's DBCXGetProp() function.
>>
>>>Hi, all.
>>>
>>>I hope my question isn't too obscure to understand. I know what I need, I'm just not sure I'll frame the question correctly.
>>>
>>>I need to determine, from within a program, whether a view is parameterized. More to the point, I need to determine: (1) the list of parameters, (2) the types of parameters and (3) which operator is used with the parameter.
>>>
>>>It doesn't appear that DBGETPROP(cName, 'View', 'ParameterList') will give me what I need if the parameters are only "defined" in the filter/where, as opposed to being listed in the "View Parameters".
>>>
>>>But, I'm willing to compromise if there is another solution. :) I'm really only wanting to take views offline, and using CREATEOFFLINE() prompts me with the parameters. Since I'm trying to make this whole routine generic, I won't know in advance what views are present, which views are parameterized nor what the parameters are asking for.
>>>
>>>So, I either want to determine what parameters are required by the views, so that I can create them, open the view and not have the user fuss with the prompt. Or, I need to be able to somehow use CREATEOFFLINE() without being prompted for the parameters.
>>>
>>>Any suggestions?
>>>
>>>Thanks,
>>>
>>>-Bri.