Thanks Dr R>
That was it! (duh)
Ben Petersen
On 18 Feb 2004 at 14:32, A. Razzak Memon wrote:
>
> 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
>
