Check out Erik Moore's GENTABLE function in the files section.

Included with it is a funtion GENVIEW which you can run on yourview then study the resulting code to see how it works.

Or you might just want to run the function from within your program to create the view definition code to a prg file and then run the resulting prg.

Good Luck



>I want to create view programaticly but that view must be updatable as good as I created it with the View wizzard & select tab Update criteria.
>
>The UPDATE SQL not works for me because in that view user can insert new records, change old one etc.
>
>How can I generate programaticly that kind of View?
>
>
>TIA
>
>Boris