Knowledgebase
[QODBC-Desktop] 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 (2)
Dave
08 December 2017 08:30 PM
I am receiving the same error, but I am working with a test company file. So all I am doing is changing a single item name and then trying to link/update/save the table, but I returns with the same error. #10003.
Jack
11 December 2017 08:27 AM
Hi Dave,

The Item table is a read-only table view of the ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, and ItemGroup tables.

You need to execute the query on the actual table which contains Items (i.e. ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, and ItemGroup tables.)

If you are still the facing issue, Please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:
http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

We may need the following information, Please attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About
2) Screenshot of the issue you’re facing.
Share Entire Log Files as an attachment in text format from
3) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
4) QODBC Setup Screen -- > Messages -- > Review SDK Messages
Refer: How to take screenshot: www.qodbc.com/links/screenshot.htm
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).