Hi!

1. There are no much of complexity, you can create view using "&" for query in the CREATE SQL VIEW command. Then configure view parameters to make it updatable using DBSetProp() function.

2. It is not a good idea because it is slow to recreate all views at the each application start, though sometimes it might be needed depended on what your final goal of making things this way. It is not worth to do it just to have several different versions of the view.


>I am considering creating view programatically, instead of saving the definitions in the database. I am not (currently) asking how to do it; I will try to figure it out from the help, first.
>
>I think I may gain some flexibility, like having several slightly different versions of a view (say, with different parameters).
>
>What I do want to ask is:
>
>1) Is it very complicated to create views programatically?
>
>2) Is it worth the trouble? That is, perhaps there are too many problems involved, or perhaps there are better ways to do it.
>
>TIA, Hilmar.