Mechanical Music Digest  Archives
You Are Not Logged In Login/Get New Account
Please Log In. Accounts are free!
Logged In users are granted additional features including a more current version of the Archives and a simplified process for submitting articles.
Home Archives Calendar Gallery Store Links Info

Spring Fundraising Drive In Progress. Please visit out home page to see this and other announcements:     Thank you. --Jody

MMD > Archives > August 1997 > 1997.08.10 > 07Prev  Next

Databases for Roll Collections
By Frank Himpsl

In reference to the discussions on roll data-basing, particularly
regarding medley rolls, the trick I've used is to define a sequencing
variable field in addition to the roll serial number field.  This
number (the sequence variable) is simply "0" for an entry corresponding
to the title of the medley.

For example, the collection entry for QRS 200499 with sequence variable
=0 is the title:  "Medley of Song Hits From Current Broadway Successes."
I then proceed to list each of the individual songs on the medley, using
the same parent serial number but with successive sequencing numbers, in
alignment with the original tune ordering.   The first tune, "Rose of
Washington Square" is listed under parent 200499 with sequencing variable
=1.  And so on for all the tunes on the roll.

Using this technique, if you want to sort all your medley rolls JUST by
title of the medley, you simply query on parent roll number plus sequence
=0.  This method also works well for nickelodeon rolls.  Even if the
original roll didn't have a "medley" title (such as "Blues From
Dixieland", or something like that), you can name it by company and
number (i.e. Clark A-345).

Frank Himpsl

(Message sent Mon 11 Aug 1997, 02:22:25 GMT, from time zone GMT-0400.)

Key Words in Subject:  Collections, Databases, Roll

Home    Archives    Calendar    Gallery    Store    Links    Info   

Enter text below to search the MMD Website with Google

CONTACT FORM: Click HERE to write to the editor, or to post a message about Mechanical Musical Instruments to the MMD

Unless otherwise noted, all opinions are those of the individual authors and may not represent those of the editors. Compilation copyright 1995-2019 by Jody Kravitz.

Please read our Republication Policy before copying information from or creating links to this web site.

Click HERE to contact the webmaster regarding problems with the website.

Please support publication of the MMD by donating online

Pay via PayPal

No PayPal account required

Translate This Page

. .