Automatically fix differences between table struct and dd
On DBF table open, check table structure vs data dictionary structure definition and adjust dictionary definition if different.
I have a program which does this. It has been working for Medisoft since 1992. If anyone is interested contact me dave
Agreed, this would be helpful. We frequently have tables that were modified outside of the DD using DOS tools and they get out of sync. Currently, the only to resolve this is to remove the dbf table from the DD and add it back. If this could be resolved automatically by refreshing the DD that would be great.
Give us 3 option:
1. just refresh the dictionary
2. update the table structure
Marcus Herz commented
This request should be extended to a call to update all tables at once after installing a new add. Just updateing one table can lead to problems with RI or other dependancies.
Don't think so. At least not automatic on every table open operation. Maybe a new ARC32 option to execute manually to refresh DD info.
very useful...but keep in mind to check if the new structure can be used with the other table/database properties and objects (e.g. if a view selects from a field which vanished)
i think this will be very helpfull
Kiron Joseph commented