SQLSTATE = 23000 error

From: ylona schneider (anonymous_at_discussions.microsoft.com)
Date: 07/01/04 

Date: Thu, 1 Jul 2004 07:35:13 -0700

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?

Relevant Pages

  • Re: Not specific access question, need help please
    ... DB2, SQL Server, MySQL). ... The database needs to store the data securely, ... Your focus needs to be on business process analysis. ... > SQL or Visual Fox Pro say that once a core module is built e.g. ...
    (microsoft.public.access.modulesdaovba)
  • Re: OO vs. RDB challenge
    ... Oracle, DB2, SQL Server, etc. ... >>May I remind you that a DBMS is a program that has it's own business ... cannot be enforced by a DBMS? ... I didn't say that a RDBMS could *not, never, in any way* be used to ...
    (comp.object)
  • Resource Planning - New Employee training
    ... SQL DBA ... Our Content Management is put back on the business side to ... >submit my thoughts for a SharePoint administrator. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Import problems on Windows Server
    ... database consultant before you had any "industrial experience." ... Tony Rogerson, SQL Server MVPhttp://sqlblogcasts.com/blogs/tonyrogerson ... explain to banks, especially where I was working two jobs. ... I've never gotten any business from the yellow pages, ...
    (comp.databases.oracle.server)
  • Re: Non Updateable Recordset -- OOOOPS
    ... I just noticed that your SQL includes some functions that modify the ... > has a Business ID field as a relationship to the business table. ... The query has fields in all three files to be able display ...
    (microsoft.public.access.forms)