Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

SYS_PK_47 Duplicate Value [key]

Using a query View with a List Box to find a "MemberID" by searching the drop-down list. The source table for the query is the same table being used in the search process. When trying to run this, I receive "Error updating current record: Violation of unique constraint SYS_PK_47: Duplicate value for column "MemberID" in statement UPDATE "MemberMaster" SET "MemberID" = ? WHERE "MemberID" = ? Error updating SQL Status 23000 Error Code 104 As a newbie, I'm lost to find this problem. Can I get some diretion

SYS_PK_47 Duplicate Value [key]

Using a query View with a List Box to find a "MemberID" by searching the drop-down list. The source table for the query is the same table being used in the search process. When trying to run this, I receive "Error updating current record: Violation of unique constraint SYS_PK_47: Duplicate value for column "MemberID" in statement UPDATE "MemberMaster" SET "MemberID" = ? WHERE "MemberID" = ? Error updating SQL Status 23000 Error Code 104 As a newbie, I'm lost to find this problem. Can I get some diretiondirection C:\fakepath\SAS Member Master.odb