CREATE TABLE sa2.vbintegrationlogmerchant ( VBIntegrationLogObjectID int(11) NOT NULL AUTO_INCREMENT, ChangeObject varchar(10) binary NOT NULL DEFAULT 'Merchant', MerchantID int(8) NOT NULL DEFAULT 0, ParentMerchantID int(8) NOT NULL DEFAULT 0, PartnerID int(8) NOT NULL DEFAULT 0, MerchantCategoryID smallint(4) NOT NULL DEFAULT 0, Enabled bit(1) NOT NULL DEFAULT b'0', CorporateIdentity varchar(32) binary NOT NULL DEFAULT '', Name varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '', Alias varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '', CareOf varchar(64) binary NOT NULL DEFAULT '', Address varchar(64) binary NOT NULL DEFAULT '', Zip varchar(16) binary NOT NULL DEFAULT '', City varchar(64) binary NOT NULL DEFAULT '', CountryID char(2) binary NOT NULL DEFAULT '', Phone varchar(32) binary NOT NULL DEFAULT '', Fax varchar(32) binary NOT NULL DEFAULT '', Email varchar(64) binary NOT NULL DEFAULT '', Contact varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '', vbVismaId int(10) NOT NULL DEFAULT 0, vbTerminated bit(1) NOT NULL DEFAULT b'0', TestmodeOnly bit(1) NOT NULL DEFAULT b'0', PRIMARY KEY (VBIntegrationLogObjectID), INDEX objectID_changeobject (VBIntegrationLogObjectID, ChangeObject) ) ENGINE = INNODB AUTO_INCREMENT = 3486 AVG_ROW_LENGTH = 187 CHARACTER SET latin1 COLLATE latin1_bin; _________________________________________________________________________________________________ Insert SQL: string command = "INSERT INTO sa2.vbintegrationlogmerchant(" + "ChangeObject," + "MerchantID," + "ParentMerchantID," + "PartnerID," + "MerchantCategoryID," + "CorporateIdentity," + "Name," + "Alias," + "CareOf," + "Address," + "Zip," + "City," + "CountryID," + "Phone," + "Fax," + "Email," + "Contact," + "vbVismaId," + "Enabled," + "vbTerminated," + "TestmodeOnly" + ")" + "VALUES(" + "@ChangeObject," + "@MerchantID," + "@ParentMerchantID," + "@PartnerID," + "@MerchantCategoryID," + "@CorporateIdentity," + "@Name," + "@Alias," + "@CareOf," + "@Address," + "@Zip," + "@City," + "@CountryID," + "@Phone," + "@Fax," + "@Email," + "@Contact," + "@vbVismaId," + "@Enabled," + "@vbTerminated," + "@TestmodeOnly" + "); " + "SELECT LAST_INSERT_ID()"; _________________________________________________________________________________________________ Error generated in client: Duplicate entry '3476' for key 'PRIMARY'