Hi!

You have to use a lot of DBSETPROP() calls!

To get an idea what you have to do try the following:
- Create a new test folder.
- Create a test database in this folder.
- Create a view similar like your sample using the view designer (including all update stuff etc.).
- CLOSE DATAB ALL
- Run the tool ...VFP7\Tools\GenDbc\GenDbc.prg - this tool creates the complete source code to recreate a DBC!
- It will ask your for the source database and for the wished location of the PRG file to create!
- After running GenDbc have a look at the created PRG - there is one procedure which is related to your view and you can cover the code!