To update a PriceLevelPerItem we do this:
UPDATE PriceLevelPeritem SET PriceLevelPerItemCustomPrice = 43.21, PriceLevelPerItemItemRefListID = 'F0000-933272656' WHERE ListID = '30000-1197755980' AND PriceLevelPerItemItemRefListID = 'F0000-933272656'
Due to a bug in QODBC v6.00.00.155, you need to use PriceLevelPerItemItemRefListID in the WHERE clause, later revisions will only need the ListID to be used in the WHERE clause.
I am running QODBC 7.00.00.214, so I should not have to use the PriceLevelPerItemItemRefListID in the WHERE clause, correct? If I don't use it, I still get the EditSequence error. If I do use it, no error. But, here is what I really need to do: update the PriceLevelPerItem.PriceLevelPerItemCustomPrice to equal ItemInventory.SalesPrice * ItemInventory.CustomFieldLevel2 (a custom field). So, I'll need a join to link up the PriceLevelPerItem table with the ItemInventory table. When doing preliminary testing to try to get an update to work when accessing more than one table, I have been using statements such as (I'll deal with putting the math in after I successfully update while linking tables):
UPDATE PriceLevelPerItem LEFT JOIN ItemInventory ON PriceLevelPerItem.PriceLevelPerItemItemRefListID = ItemInventory.ListID SET PriceLevelPerItem.PriceLevelPerItemCustomPrice = 10 where PriceLevelPerItem.ListID = '80000008-1182618742'
This produces an error saying "Expected lexical statement not found: SET".
What am I doing wrong?
Thanks for your help.
