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.