
December 3rd, 2002, 10:27 PM
|
 |
Contributing User
|
|
Join Date: Oct 2001
Location: New Zealand
|
|
|
Hmm, a long list of chords per track?
Well, two simple tables:
TRACKID NUMERIC,
LYRICS BLOB,
GUITAR_TAB BLOB
and a look-up table:
CHORDID NUMERIC,
FINGER_PATTERN VARCHAR(5) ... assuming you use five fingers.
Would store the data.
GUITAR_TAB could be a long sequence of two digit numbers from 00 (a rest) upwards that represent a CHORDID in the look-up table. This way you simply do a while loop in your program to get all the chords back.
Now, as you rightly say, you need to calculate the coordination of the two... hence you need to replicate some sequencing method such as Cubase where each value is given a duration. This is easy for the guitar tabliture as you simply add another two digits to the two for the chord, these two representing the duration. How you do the duration of the lyrics though is something I can't work out. Possibly you give each word a duration, but then it makes the adding and extraction of lyrics a complicated one, no simple cut and paste job. When extracting the lyrics you have to somehow get the figure and the word separate, not impossible but not easy.
Any help?
|