>>>>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

Bob,
if it's that good and that cheap I will look at it ( should have known better with DH )
Thanks very much for your time
Pete Kane