Ben,
Try the following syntax:
ALTER TABLE `tablename` ADD UNIQUE (`columnname`) +
('Values for rows in tablename MUST be Unique')Notice the IDQUOTEs as well as the parenthesis.
Have fun!
Very Best R:egards,
Razzak.
At 11:00 AM 2/18/2004 -0800, Ben Petersen wrote:
I must have some brain freeze going on... can someone tell me what's wrong with this statement:
alter table ar_Invoice add unique invoicenum ('Invoice Number must be Unique')
I get the error: "Missing opening parenthesis"
Thanks
Ben Petersen
