To change an item on the database requires entering a single song, artist or media item on the home page. Selecting the change button takes you to the Change screen where the new value is entered. Selecting Continue validates the change request and selecting Update applies the change to the database. Once the change is complete additional changes can be started from the Change screen for that table.
For any item that is entered it can have either zero, one or many reference related items (ex: A song having multiple artist who have recorded it). If the value an item is being changed to already exist on the database then all references to the 'From:' item will be attached to the 'To:' item. Values entered into the Media field do not allow forward slash. This is because a forward slash is the separater value of the media and company fields when viewed in a List. If Media is inserted to the database without entering a Company value, Company will be assigned a blank key value. Media and Company values are combined to make a unique value.
All updates made to the database pass through case preference check prior to updating the database. Preferences are covered under Options.
The screen print on the left shows a song title being changed. After entering the "To:" value and selecting 'Continue' a message showing the status of the request is displayed. If the change verification is successful then selecting 'Update' will complete the change request.
If the value of the "To:" field does not exist on the database it will be inserted and all references items from the old item copied under the new item. If the "To:" value does exist on the database the references under the old item will be combined with any reference items already associated with the "To:" value.
The " - a" tag identifies artist references that will be moved under the "To:" value song and the " - m" tag identifies media references that will be moved under the "To:" value song. The ' - a' and ' - m' tags are only attached to the end of the displayed items when a song is being changed.
When changing a artist or media value the listed references will always be references to a song.
When applying changes to the database the change must begin from the home screen by selecting the 'Change' button. Additional changes can be entered while on the 'Change' screen.