Unique Constraint Violation Error.

Results 1 to 2 of 2

Thread: Unique Constraint Violation Error.

  1. #1
    Capo Guest

    Default Unique Constraint Violation Error.

    My SQL stmt is error free and I have no constraint issues. The data posts to the database ok. How do I avoid the error below. Here is the SQL stmt as well.<BR><BR>INSERT INTO space_loc_sect (LOC_ID, SECT_ID, SECT_TOTAL_LINEAR, SECT_TOTAL_LINEAR_UOM, BASEDECK_DP, BASEDECK_DP_UOM, BASEDECK_HT, BASEDECK_HT_UOM, SHELF_HT, SHELF_HT_UOM, ST_RECD_LAST_UPDT, ST_RECD_LAST_UPID) VALUES (&#039;1074&#039;, &#039;BBFM&#039;, 9999, &#039;FT&#039;, 999, &#039;IN&#039;, 99, &#039;IN2&#039;, 9, &#039;IN3&#039;, trunc(sysdate), &#039;JohnDoe&#039;)<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80040e14&#039; <BR><BR>[Oracle][ODBC][Ora]ORA-00001: unique constraint (RDWADM.SYS_C001729) violated <BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default NOT an ASP question

    If you have a Db question PLEASE post in the Db forum<BR><BR>Basically you are trying to insert a value into a column in the table where there is a unique constrain and it does NOT allow duplicates....you already have the same value in another row so the insert is failing.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts