>How do you programmatically update a view after you modify a structure so you don't get "base fields have changed" message
We have a views program with all the view definitions in it... when tables are changed, we run the program and recreate our views database.
Our application stores the views.dbc on the local drive - so we just copy the files to the local machine from the network when first run.
If you want some code examples - i'll email them to you >gd&r<
Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown