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. |