Let us know how it turns out.

By the way, there are some nice utilities in the library which Erik Moore has written to provide supplemental support for working with views, tables and the DBC.

eView -- is an interactive application which provides some capabilities along the lines of the view designer, plus enhancements. Many folks start off in the view designer and then use eView to complete complex views or for maintenance purposes.

GenDBC and its children -- GenView, GenTable -- do what they sound like -- generate the Fox code for DBC, view and table generation.

Of course, for stored procedures, you can simply open up the stored procedure file, select and copy it into the clipboard and then copy into a separate PRG file.

Jay