>>I constantly have to manually update the DBCs used by my apps ( adding tables, views fields etc... ) has anyone devised a good generic(ish)method/class for this?, I currently use Gendbc, modify the output, run it but it's a bit of kludge/real drag
>>TIA
>>Pete Kane
>
>It depends on what your are doing. Most of these things can be done using the database, table and view designers... what are you trying to avoid?
>
>As a side note, I have posted two utilities here called gentable and genview that do the same thing as gendbc, but on a single table or view. A little easier than wading through the ocean of code created by your entire database...
After seeing the other replies to your post I realized you were talking about remote sites.
I must also recommend SDT in this case.
I don't use SDT except on a site where I am constantly doing what you are asking about. it has a lot of features, but this one is the one that makes it worth it to me. The table and view designer are prohibitively slow, so I make all my with the VFP designers and then run SDT UpdateMetadata() method to synch up the metadata.
Erik Moore
Clientelligence