List:General Discussion« Previous MessageNext Message »
From:Scott Hamm Date:September 26 2005 5:59pm
Subject:INDEX
View as plain text  
How do I set Index to enforce that ONLY 1 QAID can own that order number,
but nothing else?

For example:

QAID [order] ErrorType
11223 123456789 19 'ALLOWED TO HAVE different ErrorTypes as long as one QAID
number uses it.
11223 123456789 19 'VIOLATED cannot have same ErrorTypes -> UNIQUE INDEX
(QAID,[order],ErrorType)
11223 123456789 15
11223 123456789 NULL

11240 123456789 14 'VIOLATED -- order was owned by QAID 11223, therefore can
not used by different QAID

--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html

Thread
INDEXScott Hamm26 Sep
  • Re: INDEXSGreen26 Sep
Re: INDEXSGreen26 Sep