CFAMS V3 Cummulative Patches
Date / Problem / Fix / App object /Nov 29, 2006 / The source window would not generate a source number greater then 175520063
The script in the window, w_source open event recognized that sources existed but would generate the source ID as 175520063 every time.
When the user pressed the save button they would get an integrity violation error because the primary key already existed.
The PK generation issue did not affect the generation of the initial value. / Commented out the datastore and loop which was not generating the correct number and replaced it with a select statement to the source table requesting the max source ID.
The return value from the select statement was then incremented by 1 to generate the new number.
The new primary key value was accepted by the database and no further data integrity messages could be generated.
An empty DB was used and initialized with a museum id of 1755. 10 new sources were created without any further issues. This was done three times and all were successful. The test BD’s were then replaced with the DB provided by the Strathcona’s museum and the fix was tested against it. No data integrity issue was generated and ten additional sources were accepted. / - Modified w_source open event
- commented out the original code from line 45 to 58.
- Inserted lines 59 to 64.
- Modified the about window to CFAMS V3.1 Nov 29 Build.
- The application was recompiled and built.
- No other portions of the application were modified.
- An install shield single file install was created to replace the application executable and its 5 .pbd support files.
Dec 29, 2006 / Slow retrieval of the artifact search screen when the search artifact window is called.
The links in the SQL statement between the artifact, source, and artifact classification tables caused a slow retrieval when the result set was larger then 5000 records.
At 12000 artifacts the retrieval was taking over 30 minutes. / An identical datawindow was created without the links for the initial display of default artifact information.
When the user selects a criteria the original datawindow replaces the default to generate the dataset based on a criteria.
The retrieval time was brought down to 9 seconds at 12000 artifacts. / - Modified w_select_artifact open event
- set DW_1 to visible = false
. Modified w_select_artifact search button clicked event
- Inserted lines 1 to 5 to flip flop the datawindows
.
- Modified the about window to CFAMS V3.1 SP1 Dec 27 2006 Build.
- The application was recompiled and built.
- No other portions of the application were modified.
- An install shield single file install was created to replace the application executable and its 5 .pbd support files.