>I need to programatically change the structure of a table which is part of a database of dbc. I am doing an update to an application and need to add a field while retaining the data in that table.
>
>Any help would be greatly appreciated.
>
>Scott
To change a single field, you can use ALTER TABLE.
For regular updates, I wrote a program that copies (APPEND FROM) for each table. The tricky part is that if there is a parent-child relation, with RI, you have to copy the parent first. You can get the information about these relations with adbobjects().
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)