Scott Hamm <linuxgold@stripped> wrote on 09/26/2005 01:59:52 PM:
> How do I set Index to enforce that ONLY 1 QAID can own that order
> but nothing else?
> For example:
> QAID [order] ErrorType
> 11223 123456789 19 'ALLOWED TO HAVE different ErrorTypes as long as one
> number uses it.
> 11223 123456789 19 'VIOLATED cannot have same ErrorTypes -> UNIQUE INDEX
> 11223 123456789 15
> 11223 123456789 NULL
> 11240 123456789 14 'VIOLATED -- order was owned by QAID 11223, therefore
> not used by different QAID
Please post the output from SHOW CREATE TABLE. That way I can see not only
what your columns are actually called, I can also see what other keys have
been defined on the table.
Unimin Corporation - Spruce Pine
|• INDEX||Scott Hamm||26 Sep|
| • Re: INDEX||SGreen||26 Sep|
|• Re: INDEX||SGreen||26 Sep|