Getting Started Guide

Figure 177: Changing field types
Note
If any of these fields requires an entry, set Entry required to Yes. An entry
with that field blank will then not be allowed. In general, only set Entry
required to Yes if something must always be put in that field. By default,
Entry required is set to No.
• CollectionID: Change AutoValue from No to Yes.
• AlbumTitle:
– Entry required: Leave Entry required as No, unless all of your music is in
albums.
– Length: Unless you have an album title that exceeds 100 characters
counting the spaces, do not change the length.
Note
In Base the maximum length of each field must be specified on creation. It
is not easy to change this later, so if in doubt specify a greater length.
Base uses VCHAR as the field format for text fields. This format only uses
the actual number of characters in a field up to the limit set. So, a field
containing 20 characters will only use space for 20 characters even if the
limit is set at 100. Two album titles containing 25 and 32 characters
respectively will use space for 25 and 32 characters and not 100
characters.
• Artist: Use the Default setting. And since music has artists, set Entry Required
to Yes.
• Date Purchased: Field type: default date setting. Entry required should be No.
(You may not know the date.)
• Format: Only change the Entry Required setting: from No to Yes.
• Notes: No changes are required.
• NumberofTracks: Change the Field Type to Tiny Integer [TINYINT]. Your
allowable number of tracks will be 999. Small Integer [SMALLINT] would
allow 99999 tracks if you needed more than 999 tracks.
• Photo: Use the default settings.
When you have finished, click Next.
Chapter 8 Getting Started with Base 207