This very simple update statement throws an error...

UPDATE Vendor SET Name = CompanyName

[QODBC] Error: 3170 - There was an error when modifying a Vendor list, element "10000-1162316208". QuickBooks error message: Cannot merge list elements.

I cannot get this simple statement to work in the VB Demo or in ColdFusion using <cfquery>

Thanks,
Marty

Sorry, you forgot the WHERE condition. This should work:

UPDATE Vendor SET Name = CompanyName where CompanyName <> Name

I wish it were that simple, but adding the WHERE clause did not work.  I also tried just updating one record, but it failed as well:

UPDATE  Vendor
SET  Name = CompanyName
WHERE VendorTypeRefListID = 'A0000-1162316191'

Any other ideas why I can't update the name field in the Vendor table?

I actually got:

UPDATE Vendor SET Name = CompanyName where CompanyName <> Name

to work last night from home using the Australian version of QuickBooks. But you are correct, operations such as these gave me errors using QuickBooks 2006 Sample Rock Castle Construction sample company file and QODBC v7.00.00.199 at work today:

UPDATE  Vendor
SET  Name = CompanyName
WHERE VendorTypeRefListID = '40000-933272658'

[QODBC] Error: 3190 - Cannot clear the element in the Name field.

UPDATE  Vendor
SET  Name = CompanyName
WHERE name = 'A-2'

[QODBC] Error: 3190 - Cannot clear the element in the Name field.

Even though I got the following to execute without errors, it did not update the Vendor name in QuickBooks:

UPDATE  Vendor
SET  Name = 'A2 Sanitation Service'
WHERE name = 'A-2'

The problem has been logged.

I have run the following statements using QODBC v7.00.00.207 and QuickBooks 2006 Premier (USA version):

UPDATE  Vendor
SET  CompanyName = 'A-2'
WHERE name = 'A-2 Sanitation Service'

UPDATE  Vendor
SET  Name = CompanyName
WHERE name = 'A-2 Sanitation Service'

UPDATE  Vendor
SET  Name = CompanyName
WHERE name = 'A-2'

UPDATE  Vendor
SET  Name = 'A2 Sanitation Service'
WHERE name = 'A-2'

and all ran without error and correctly executed the changes in my company file.