I use Clarion 11 to create a front end to a sqldatabase in ms sql express. I usually create the database first with MS Sql Server Management Studio. The tables I then import into the application’s dictionary.
This works fine and there is no big problem with that. But the problem for me is that I always need to make changes to the database afterwards. I need to add fields, change field types, create relationships etc.
I try to update the dictionary manually afterwards to reflect the changes in the tables and this works most of the time.
But the best approach is import the updates tables and give them a new name in the dictionary. Afterwards I need to update all the browses, forms, trees etc with the new tablechanges. This is a lot of work.
I would like to get some advise from the community on what is ‘best practices’ that works best for other developers when they need to update their database back end.
Thanks in advance.