1 reply to this topic

[manfredrunkel]

Hi!

 

I would like to know if there are some way to add the unique rule for two or more fields,

 

for example,

 

i have this unique index

 

 

ALTER TABLE `mytable` 

ADD UNIQUE INDEX `uq` (`year` ASC, `month` ASC, `idclass` ASC)

 

i would like to prevent the user (and show a message) that he is not able to insert the value due the unique validation.

 

I've tried 

 

is_unique[mytable.month]|is_unique[mytable.year]

 

but didn't work.

 

Thank you

[victor]

there's some posts about is_unique problem. try use search.