Subject | Re: Inserting only one row for each distinct id (ignoring duplicates) |
---|---|
Author | dinol.softedge |
Post date | 2008-11-24T10:36:37Z |
--- In firebird-support@yahoogroups.com, Kjell Rilbe <kjell.rilbe@...>
wrote:
INTEG_36 refers to Inventory_ID constraint
wrote:
>see
> dinol.softedge wrote:
>
> > Right you are. Sorry I failed to mention that stock code is a unique
> > constraint. I removed it as a unique but I am still getting the same
> > error. ??
>
> The error message mentions the name of the constraint. Trace that to
> what column(s) have the unique constraint that gets violated. UseHi
> FlameRobin or some other easy-to-use tool to obtain and interpret the
> relevant metadata.
>
> Kjell
> --
INTEG_36 refers to Inventory_ID constraint