"Mitchell Vincent" <[EMAIL PROTECTED]> wrote: > Here we go. I am accessing the database through an ODBC connection > using the most recent version from Christian's site.. > > The table schema : > > CREATE TABLE invoice_items ( > item_id INTEGER PRIMARY KEY, > invoice_id int4, > product_id int4, > product_name text , > sku text , > description text , > quantity text, > price int4, > cost int4, > taxable bool, > format_price text, > format_total_price text, > taxable2 boolean) > > The query : > > INSERT INTO invoice_items > (item_id,invoice_id,product_id,product_name,sku,description,quantity,price,cost,taxable,taxable2,format_price,format_total_price) > VALUES (NULL,899,1001975,'HD0001 - ASH - YL','','HOUSE > DIVIDED',1,800,450,'f','f','$8.00','$8.00') > > The error : > > PRIMARY KEY must be unique (19) >
I wonder if this error might be coming from a TRIGGER and not from the INSERT statement itself? -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
