Having trouble logging in or locating tickets ?


 

Knowledgebase
TroubleShooting: Cannot Update Item table
Posted by Rajendra Dewani (QODBC Support) on 06 December 2012 06:58 AM

 

Problem Description

Trying to change the cost of an assembly using the following query:

UPDATE Item set SalesPrice = 1500.00, PurchaseCost = 700 where Name = 'Blueprints';

It fails with the error: "error: [QODBC] Not supported

http://support.flexquarters.com/esupport/newimages/ItemUpdate/Item.png

or

UPDATE the price in the ITEM table

Update Item Set SalesPrice=45 where Name='S1'

Solution


The Item table is a read only table view of the ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, and ItemGroup tables. Your update statement needs to run against the actual table with the item in it.

Example
UPDATE ItemInventory set SalesPrice = 1500.00, PurchaseCost = 700 where Name = 'BluePrints'

 

http://support.flexquarters.com/esupport/newimages/ItemUpdate/Item1.png

 

Keyword: QODBC Not Supported.

(4 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).