Control SQL update error

Hello Friends,

One question.

I have a chronoforms and chronoconnectivity mannagement table. All is running ok,
http://www.allscooters.es/trucos-2.html

But. In table there is an INDEX with three fields.

Rider, trick and execution. (INDEX UNIQUE)

Rider->trick->execution
1->whip->flat
1->whip2->flat
1->whip2->rail <----


1. edit record three from connectivity
2. Change rail to flat
3. Submit save - >chronoaction

ERROR 1062 Duplicate entry-

Is perfect ------
But can I control the message into chronoforms????
I would like to warn to user for to change the field three for another option.

Is posible??

I've tryed with server validation but NO ....

Hi ideagrup,

I think that this could be done by using Custom Code to check the database entry before the DB Save action - or maybe by checking on On Load and disabling the existing combinations somehow.

Bob

It was assumed this
ok then i will check the drop-down before saving changes to limit the content.

Thank's Bob,

Thomas