>>>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
>>
>>Have you looked at Stonefiled Database Toolkit?
>>
>>BOb
>
>Bob,
>Thanks, no I haven't, presumably it has something along these lines, I'm more into third party ideas than third party products, as I don't like tying my clients into products that I can't support directly, I just thought somebody on the UT might have posted something ( no offence Doug He....)
>Thanks again
>Pete Kane

I understand... You could look at DBCX2, which is the public domain metadata (data dictionary) spec an managment class that SDT uses.

Basically, SDT has enhanced to allow you to take an updated datadictionary and DBC, ship them to a client, then call update() and SDT will sync the datafiles to the new metadata.

There is an article about DBCX2 in a recent FoxTalk if you are interested.

RE: Third party products... I know this is off the subjects, but our experience is that we can get alot more functionality with a $200-$500 third party product then if we tried to create it ourselfs. We could probably write our own 'SDT' but it would take about a man year or so, so we are way ahead. Even if we don't use the product in our release. Anyway... just my thoughts on that, to each his own.

BOb