[Gambas-user] error trap an sql insert on a unique column

[john hedge]

Hi,

I'm trying to setup a user input unique code.

If the user enters a non unique code the error message "Query
failed........." Stop Continue etc. appears and the program exits.

Is it possible to capture this process before this occurs, as in TRY
conn.Open and displays a relevant message indicating duplication?

I've attached a screen shot which I hope helps show the situation.

TIA

John
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20051208/e88fc1c7/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot.png
Type: image/png
Size: 147366 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20051208/e88fc1c7/attachment.png>