- Create the view in the database with the View Wizard
- Make sure that the database is currently selected
- DO (Home() + "\Tools\GenDBC\GenDBC.PRG") WITH "C:\MyDBC.PRG"
- MODIFY COMMAND C:\MyDBC.PRG
- Trim all the codes that doesn't relate to the view

HTH

---

>I've created an updatable view using the View Wizard, but was wondering if there was someway to get the code so I can do it on the fly instead of having to have it in my DBC?
>
>I've looked at the CREATE VIEW command, but that doesn't seem to be what I need.