On Sep 21, 2006, at 11:52 AM, Matthias Buercher wrote:
if you are starting to have questions like this, then you may need
to rethink your database structure. if you rely on an external
function tor special sql update sequence to get what you want, you
will have soon a problem, where the data is not consistent. what
for example, if you need to delete or duplicate the selected row?
then you will have 0 or 2 true.
you probably need a new table leadguitarrist with the fields band
and musicianid.
matthias
That's about what I'd have thought (although I had a "role" table)
but any person could hold any role
Roles were settings like author, lead singer, lead guitarist,
producer, engineer, etc
And, in some cases we even had the same person as several roles on
the same track (Paul McCartney does this a lot)
We did not add the same person as any role twice (although some
tracks do have the same person playing two lead guitars and it's been
multitracked)
Very odd stuff indeed
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
