On 22 Feb 2002 at 2:46, Alan J Davies wrote:

Your procedure should look like that:

> CREATE PROCEDURE PARTNO_INSERT
> (
> PART_NMBR CHAR(16) /* New Part # */
> )
> AS
> Begin /* Partno is Unique
> - Index exists and works ok */
> Insert into Partnos(Partno) /* Create New Part */
> Values (:Part_Nmbr); /* New Part # */

When SQLCode -803 Do
Exception InsertPart;

> end

SY, Dimitry Sibiryakov.