> I'd say, add a "unique_items" bool to the container table, and have a > trigger on the item table check that in a BEFORE UPDATE OR INSERT > trigger. Eh?
I like this. Do we want to silently turn an INSERT into an UPDATE on collision or provide an error? -- Jason Etheridge | VP, Tactical Development | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email: [email protected] | web: http://www.esilibrary.com Please come by and visit the Equinox team and learn more about Evergreen ALA MidWinter January 15-18, 2010 booth # 2064
