>Hi!
>
>My problem is that I got to create a parameterized view at runtime, and
>for some reason every time I execute the code to do it I get a window
>asking for the parameters.
>How can I avoid that?
>
>I'm creating the view at runtime as one of its tables is a cursor.
>Is there any workaround to make this cursor appear like a table of the dbc
>and so avoiding creating the view at runtime?
>
>Am I out of luck?
>
>TIA
Roman,
If the parameter variable exists before you create the view then it should not have to ask you for it.
As far as pre creating the view is concerned I think you can do that, as a view can use a free table so why not a cursor? Just create the cursor before you create the view and don't forget to create the cursor before you try to edit the view later on.
HTH
Caroline