[Base] Customize an error message

[jeanmi2403]

Hello,
I have a database with a field built as a unique index. When a user tries to create a record with an existing value for this field in the database, he gets this message:

MessageUnique.PNG (27.44 KiB) Viewed 967 times

I would like to be able to intercept the error in order to display a more sympathetic and "clearer" message.
Is this possible?
I think i have to use a Listener, I don't know how to implement it.
Sincerely,

[Villeroy]

https://ask.libreoffice.org/t/macros-ba ... nt/68015/3

[jeanmi2403]

Hello,

https://ask.libreoffice.org/t/macros-ba ... nt/68015/3

I am shortsighted !
Moreover, it was I who translated the Base Guide into French...
I'm ashamed
but it doesn't work for this error..

[Villeroy]

Hello,
but it doesn't work for this error..

Open the form in the attached file and enter a duplicate. You get the msgbox defined in my macro titled "Macro: SQL Error"

[jeanmi2403]

Very myopic! I hadn't seen the title of the message box.
I had simply noticed that the message was the same.

Edit: But it works only if the field is a primary key. Unique constraint on an other field do not work, the macro is not executed and the original message is displayed

Thank you very much.

[Villeroy]

My personal work-around that has been proven as good enough: Give a talking name in upper case letters to the index, so the original error message includes a not so hidden human message like "PLEASE_ENTER_UNIQUE_NAME"

[jeanmi2403]

Ok, crafty !!
Thanks