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.