Bob,

Thanks once again for a great tip. This will definitly come in handy.

Gary

>One thing that I find handy is using GENDBC from VFP\Tools\Gendbc to generate a program file of all my views. I need to do this because I have a few views that cannot be accessed in the view designer (they use SQL Server functions like convert) which causes the view designer to generate a GPF. It is handy here to verify that share connections property of the view is set to true. If it isn't, I cut the code out of the program and run it standalone to fix the view. Some of my views reference code tables that should not be part of any update statement, but sometimes the view designer includes these tables (but no fields) as tables that are part of the update. If I have a problem updating the view I can fix the parameters from gendbc and then recreate/reset the view definition. This output is very instructive, and if you database container gets trashed you can use the program to recreate it all.