General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Getting View Parameters
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only