Requested CCMDB changes for the next version: Difference between revisions

Line 33: Line 33:


=== Changing the local data structure automatically ===
=== Changing the local data structure automatically ===
Need a way to make changes to data that is stored in \ccmdb_data\ccmdb.mdb, such as adding room numbers. By Access design, \ccmdb_program\ccmdb.mdb can not touch a linked table's structure. Will need to copy down new data structure and transfer existing data into that. This gives the opportunity to rename the data version into something less ambiguous.
If it is renamed, I'll also need to change news and backup file.
==== Specific changes to make to the data file ====
* update [[Patient List]] when room nr is rolled out.
* change L_Settings stuff to go to _info instead to be able to get rid of legacy content
* update or separate article when the BP helper using L_BPs is implemented
* update or separate article when the BP helper using L_BPs is implemented
* add s_FinalChecks, fix all spots that use FinalCheck (or make a function to check it)
* add s_FinalChecks, fix all spots that use FinalCheck (or make a function to check it)
* update when done: [[CCMDB.mdb]]; [["News and backup" batch file]]; [[Settings.mdb]]
* update when done: [[CCMDB.mdb]]; [["News and backup" batch file]]; [[Settings.mdb]]
* change error code to populate L_Errors
* change error code to populate L_Errors
==== Get rid of Orphan stuff ====
Should be impossible to have orphans in the relational setup we use now, so get rid of checking and buttons.[[User:Ttenbergen|Ttenbergen]] 09:36, 2 November 2010 (CDT)


==Changes Under Discussion==
==Changes Under Discussion==