Re: SQLSTATE = 23000 error

From: Steve Kass (skass_at_drew.edu)
Date: 07/01/04 

Date: Thu, 01 Jul 2004 11:33:02 -0400

Ylona,

  This newsgroup is for Microsoft SQL Server English Query, not Sybase
Adaptive Server Anywhere, so you will probably get more help from a
Sybase group. However, my guess is that you are attempting to save a
new order under an existing order_id number, and that is not permitted.

Steve Kass
Drew University

ylona schneider wrote:

>I need some serious help.
>I know nothing of SQL or anything but our business has a
>program called Shoplink and we use it to do our order
>processing. When i try to save an order I get this error:
>
>
>[Sybase][ODBC Driver][Adaptive Server Anywhere]Integrity
>constraint violation: Primary key for table 'slc_order' is
>not unique
>
>No changes made to database.
>
>INSERT INTO "slc_order"
>( "order_id", "store_code", "order_type_code", "customer_id
>", "customer_store_code", "price_list_id", "quote_id", "quo
>te_store_code", "order_date", "confirm_date", "shipping_dat
>e", "invoice_date", "paid_date", "delivered_date", "total_a
>mount", "deposit_amount", "discount_absolute_value", "order
>_number", "invoice_number", "country_ref", "manufacturer_re
>f", "payment_form_id", "payment_form_owner_store_code", "st
>ore_note", "delivery_note", "internal_note", "remote_status
>_code", "customer_order_type_id", "delivery_address_id", "i
>nvoice_address_id" ) VALUES
>( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
>?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
>
>
>nobody can help us as the people who sold us the program
>are out of business, we have never had any problems with
>it.
>
>What can it be or where do I get help?
>
>
>
>