Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Duplicate value for column

means that MemberID is defined as requiring unique items, in other words no two records can have the same value for MemberID. It's called something like a 'unique field constraint'. Read on..

UPDATE "MemberMaster" SET "MemberID" = ? WHERE "MemberID" = ?

looks like the SQL that is trying to update MemberID and failing (when you open the pull down box and select an item).

To fix this either don't put the same thing in more than one record (via the pull down selector), or remove the constraint in your table design (the "unique" constraint) to allow multiple records to have the same value.