>>Is there a good method for adding a field to a table programatically. In the event that you have databases deployed at the client's site and you need to add additional fields (the tables already having data in them) what is the best approach? I was hoping to write an update routine that would make the necessary changes to the tables.
>>
>>Thanks in advance...
>>
>>John Dennis
>
>John,
>
>You could write your own routine that adds fields to tables with Alter Table. Or, you could also do it by using afields to get the structure, then add fields to the array, and create a table from the array.
>
>You could do a program that specifiaclly adds fields to your system, or you could do one that would be data driven.
>
>But, instead of going through all that trouble I HIGHLY recomend StoneFiled Database Toolkit from Stonefield.
www.stonefield.com. It's $300 and has the exact function you are looking for. You just ship a new .DBC and new MetaData Tables to your users, and call Stonefields update() function.
>
>In addition, that is only one of the MANY things it does, but even if it only did the above it would be worth the price. Check it out!
>
>BOb
Thanks guys...
JD