Dec 112017
A comprehensive database for record, tape, and CD collectors.
File DALBM12.ZIP from The Programmer’s Corner in
Category Databases and related files
A comprehensive database for record, tape, and CD collectors.
File Name File Size Zip Size Zip Type
ALBUM.FIL 512 184 deflated
ARTIST.NDX 1536 862 deflated
DALBUM12.DOC 20398 6512 deflated
DALBUM12.PRG 18093 17733 deflated
SONGS.FIL 512 155 deflated
SONGS.NDX 1536 239 deflated

Download File DALBM12.ZIP Here

Contents of the DALBUM12.DOC file


version 1.2

by Darryl Nichols

(c) Copyright 1987
All Rights Reserved

Table of Contents

System Requirements....................................1

Installing dALBUM......................................2

Running dALBUM.........................................2


Using dALBUM

Adding Albums to Your Catalog.....................4
Deleting Albums From Your Catalog.................5
Editing Existing Albums in Your Catalog...........6
File Backup and Restore...........................7
Printing dALBUM Reports...........................7
dALBUM Query Functions............................7
Time Calculations.................................7

dALBUM Change History..................................8


dALBUM release 1.2 11/11/87 Page 1

System Requirements

Hardware: IBM or compatible computer with a hard disk. To
obtain printed reports, you must also have an
IBM/EPSON compatible printer hooked up to your

Software: dALBUM runs under dBASE III Plus version 1.0 and
higher. Your system must meet all of those
requirements in order to run dALBUM. For more in-
formation, please refer to your dBASE manual. In
addition, the line DEVICE=ANSI.SYS must be in your
CONFIG.SYS file. Otherwise, you will get garbage
on your screen instead of the opening menu. For
more information on this, please refer to your DOS

dALBUM release 1.2 11/11/87 Page 2

Installing dALBUM

dALBUM is not copy protected and requires no formal instal-
lation procedure. However, all of the files on the distribution
diskette must be in the current directory when running dALBUM.
dALBUM can be made to handle "multi-users" by putting all of the
dALBUM files in a different subdirectory to be used by someone
else in your household or to keep two collections separate. Be-
cause the database files used and any back-ups you make will have
the same names, you will have to be careful not to mix files be-
tween users. You'll also have to check your dBASE PATH command
(if any) in your CONFIG.DB file. Make sure this PATH will not
cause any conflicts for dBASE in accessing the correct file. The
best thing to do in this case is to physically log onto the sub-
directory by using the DOS CHDIR or CD command in combination
with the dBASE RUN command. For example, from the dot prompt


followed by a carriage return. This will change subdirectories
without quitting dBASE and eliminating any confusion for dBASE
when accessing your dALBUM files.

Running dALBUM

To run dALBUM, type "DO DALBUM" from the dot prompt. The
opening logo screen will appear and you will be asked to press
Enter to begin. After pressing Enter, the MAIN MENU will appear
and you'll be ready to go. Simply press the key that corresponds
to the menu function you would like to perform. There is no need
to press the return key. Each of the dALBUM menu choices will be
discussed in detail below.

dALBUM release 1.2 11/11/87 Page 3


dALBUM is the result of a past Disk Jockey turned Record
Collector and now Computer Consultant and dBASE programmer. dAL-
BUM is a fully relational program that allows users to catalog
all albums, cassettes, compact discs, and reel-tapes. dALBUM
will handle an unlimited number of songs per album since it is
relational and uses a separate file for albums and corresponding
songs. (Of course, space is limited by the limitations of dBASE
or your hard disk, whichever is smaller. dBASE III Plus limita-
tions include a database size of 2 billion bytes or 1 billion
data records, whichever comes first.)
Information that I included such as release year and record
label may prove to be more cumbersome to enter for some, but fel-
low collectors will appreciate these fields and they also provide
for some interesting Catalog Queries!
With this release of version 1.2, a comment field has been
added as well as a time field for each song. (Please see page 8
for change details.) Future additions still left over from pre-
vious versions include:

o A Print to Disk Option for Reports

o More Query Functions (sugg. appreciated)

o Add Color (maybe user defined)

Most dBASE users should feel at home using dALBUM. The only
annoyance that may be encountered is pressing the Enter key.
dALBUM uses SET CONFIRM ON because of the one letter fields and
the scrolling capabilities of the Song Title fields.
As with all USER SUPPORTED programs, if you like, use,
and/or enjoy this program, please register your copy of dALBUM.
Information is provided on the last page of this manual.
Also, any and all feedback as well as your ideas for Catalog
Queries and/or dALBUM improvements are greatly appreciated.
Please refer to the last page for details.

dALBUM release 1.2 11/11/87 Page 4

Adding Albums to the dALBUM Catalog

To add albums to the dALBUM catalog, press 'A' from the MAIN
MENU. The screen will clear and the current function is dis-
played at the top of the screen. (This is true for all dALBUM
functions.) A field is displayed for the Artist's (or group)
name. Pressing the Enter key alone will return you to the MAIN
MENU. This is how you leave ADD ALBUMS. You must put an Artist
or Group in the Artist field or else you can't continue. dALBUM
will kick you back to the main menu because it thinks the Artist
field is blank.
After the Artist name is entered, the rest of the informa-
tion fields are provided for you to fill in as you see fit.
The Comment field appears to be only 50 characters wide, but
you can have a Comment up to 150 characters.

NOTE: The ALBUM, CASSETTE, CD, and REEL TAPE fields will take
only a 'Y' or 'N'.

After completing the first screen of information about the
album, you are able to enter the songs that are on this album.
The fields only appear as 10 characters long but don't worry -
the song title can be up to 40 characters in length. As you
type, the information will scroll within the 10 character field.
If you make a mistake while typing, use the cursor keys (arrow
keys) to move back and forth.

NOTE: You CANNOT go back and fix a previous mistake in a
songtitle even though it remains on the screen and is high-
lighted in inverse video. You can use the EDIT function
described below to fix any mistakes when entering
songtitles. Pressing the left arrow key when you are in
the first position of the field has the same effect as
pressing the Enter key. BE CAREFUL when scrolling !

After typing the songtitle in, you are prompted for the
time of that song. For songs under ten minutes, as most are, you
will have to type the leading zero. For example, a song that is
3:58 will have to be entered as 0358. You do not need to type
the colon so you could use a numeric keypad for this depending on
your keyboard.
When you've got all of the song titles and times typed in,
Press Enter and dALBUM will again prompt you for an album title.
If you are done adding albums to the catalog, just press Enter.
Or, if you would like to add more, simply keep typing. As you
can see, it is almost a must to have the album handy when doing

dALBUM release 1.2 11/11/87 Page 5

Deleting Albums from the Catalog

To delete albums from the dALBUM catalog, press 'D' from the
MAIN MENU. A field is displayed for the Artist of the album you
wish to delete. Simply Enter the information and press return.
If dALBUM finds a match for the Artist name, it will dis-
play a similar screen as the ADD ALBUM that contains the informa-
tion about this particular album. A list of four options will
then be displayed:

F1 - Abort
"plus" - next match
"minus" - previous match
Enter - Delete Album

F1 takes you out of the search; a plus will take you for-
ward in the alphabet to the next match; a minus will take you
backwards in the alphabet to the previous match; pressing the En-
ter key will delete the displayed album. This is your last
chance because there is not an option to get back deleted albums.
If you delete one by mistake, you will have to go through the
whole ADD ALBUM process again.
If and when you decide to delete an album, dALBUM will take
care of deleting all the associated songs that are on that album.
The last thing dALBUM will ask you is if you want to delete more.
A yes response will start the DELETE process over again. As with
all other dALBUM routines, this question will default to a NO
response so if you hit a key by mistake, you won't be stuck some-
place you don't want to be.
When you are done, dALBUM deletes the albums you've
selected and takes you back to the MAIN MENU.

dALBUM release 1.2 11/11/87 Page 6

Editing the information in your dALBUM catalog

To Edit albums in dALBUM, press 'E' from the MAIN MENU.
Again, a screen similar to the ADD ALBUM and the DELETE ALBUM
screen will appear. If dALBUM finds a match for the information
you supply, 4 options very similar to DELETE ALBUMS will appear
to allow you to fine tune your album search criteria. When you
find the one you want, press Enter to begin editing and another
screen will appear with your current selection and a sub-menu
with specific editing options from which you may choose. Most of
these functions are self-explanatory and all are discussed in
detail below.

1. Edit Artist - Changes the Artist's Name of the current
selection in both the album database and the songs

2. Edit Album Title - Changes the Title of the current

3. Edit Album Info - Allows you to change the format the
current selection is maintained on in the event
that you make a cassette tape or buy the CD of
your favorite album. This option also allows you
to change the release year and label in case of

4. Edit Song Titles - Used for correcting typos in song
titles that may have occurred when you entered
them or to add times if you are upgrading from an
earlier version of dALBUM. DO NOT use this option
to try and Add or Delete songs from the current
selection. You CAN'T do it! Also, the same cau-
tions apply that were mentioned under ADD ALBUMS
in reference to scrolling and going back.

5. Add a Song - Adds a Song to the currently selected Al-

6. Delete a Song - Deletes a Song to the currently
selected Album.

7. Change Selection - A nice feature so you don't have to
back all the way out to the MAIN MENU and press
Edit again.

8. Quit Editing - Returns you to the MAIN MENU when you
are done editing.

dALBUM release 1.2 11/11/87 Page 7

Backing up Your Files

Backing up your dALBUM Catalog is as easy as pressing 'F'
from the MAIN MENU. All manuals stress backing up your files,
and this one is no exception. It's not hard with dALBUM nor is it
very hard through DOS and this option just allows you to "save
and continue working".

NOTE: For this handy little function to work, your DOS PATH must
include the location of the DOS files BACKUP.COM and RESTORE.COM.
If this is not the case, you may either update your DOS PATH by
modifying your AUTOEXEC.BAT file and rebooting or place a copy of
BACKUP.COM and RESTORE.COM in the same directory that contains
the dALBUM program files.

When asked, press either 'B' or 'R' and follow DOS's in-
structions. Any other key will return you to the MAIN MENU if
you change your mind.

Printing dALBUM Reports

To get a printout of your dALBUM Catalog, press 'P' from
the MAIN MENU. You are prompted for information that will allow
you to customize the report so all you do more or less is follow
the instructions and answer the questions.
dALBUM should work with any IBM/EPSON compatible printer.
If you can't get a printout, please drop a line or call me. See
last page under HELP! for details.

dALBUM Catalog Queries

A query is when you ask dALBUM a question, or in this case,
tell dALBUM to display requested information. All of the queries
are self explanatory so the best thing to do is to play around
with them a little because I'm sure everyone will use them a
little differently.

Recording Time Calculations

To calculate the total recording time for an album, press
'T' from the MAIN MENU. You must enter the artist and if dALBUM
finds that artist, the choices that are available are the same as
the DELETE and EDIT functions. You can abort, go forward or
backward or simply press Enter and dALBUM will calculate the to-
tal recording time for the album displayed.

dALBUM release 1.2 11/11/87 Page 8

dALBUM Change History

Version 1.0 - Released 08/09/87

Version 1.1 - Released 10/13/87

Changes in Version 1.1

The only major changes in version 1.1 are the EDIT and
DELETE routines. The search is a lot quicker and you don't have
to get an exact match when entering the Artist name - you can
just enter the first letter or the first few letters if you like.
You no longer have to enter the Album title either. This revi-
sion did cause another change in dALBUM though. dALBUM is now
case sensitive - that is, if you originally put in an album with
upper and lower case, you must use upper and lower case to
retrieve that album. dALBUM now distinguishes between upper and
lower case and does not consider them equal as version 1.0 did.
A friend and fellow user of dALBUM informed me that you
couldn't get a printout for one artist, an option when generating
printouts. I confirmed this and that has been fixed. As a mat-
ter of fact, you can now print a report for one letter of the al-
phabet or for all artists beginning with 'Spr' or whatever. This
feature happened by accident as a combination of fixing the bug
and revising the EDIT and DELETE routines.

Version 1.2 - Released 11/11/87

Changes in Version 1.2

Version 1.2 contains all of the enhancements made available
to 1.1 users and additionally adds two new goodies. One was sug-
gested by a friend and the other just came to mind one evening.
Although I had thought of it before, the Comment field
comes to dALBUM via Richard Eyer. I've used the Time field al-
ready even while I was adding it because I do a lot of recording
and get tired of doing the tens column in base 6 and making mis-
takes with carry values. The MOD() function is a life saver !
I realize it's not too versatile yet as it only lets you
calculate times for an album. My needs go beyond this and there-
fore, additional time calculations are inevitable.

dALBUM release 1.2 11/11/87 Page 9


The best thing for me to tell you if you encounter an error
is to read the appropriate section in this manual. (Typical
isn't it ?) If that doesn't help and the error is serious, for
example your machine is beginning to smoke, you can get in touch
with me by dropping a note or ringing the phone.

11122 Flora Lee Dr.
Fairfax Station, VA 22039
(703) 250-0882

Another option is to leave mail on some of my frequented

BXR Info Corner - (703) 756-6109 MD/DC/VA

Sigma Industries - (707) 274-8581 Calif.

Comments, suggestions, more query ideas, bug reports, etc.
are all greatly appreciated. If you wish to register your copy
of dALBUM which will ensure you're kept up to date on future en-
hancements of dALBUM, please send a check or money order for any
amount you see fit to the above address. Be sure to include
your name and mailing address.

 December 11, 2017  Add comments

Leave a Reply