How do you add a new Item using VB6 and QODBC. When I try to add a record to the Item table I get "Error Add not supported on this table in BuildXMLHeader" from the log file

Any Ideas?

The ITEM table is a READ ONLY table that's a combined list of all Item tables in QuickBooks:

• ItemInventory,
• ItemNonInventory,
• ItemOtherCharge,
• ItemInventoryAssembly,
• ItemService,
• ItemFixedAsset,
• ItemGroup;

with minimum common fields.

When creating new items, the insert needs to be made to the ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, or ItemGroup table as applicable. It must also be a unquie new ITEM FullName!

To see the item fullnames, you can run the following query in VB Demo:

SELECT ListID, FullName, Description, Type FROM Item

Could you give us a SQL statement solution?since it is too complicated for us to know how to do.

Thanks!

See:

How do I add a Inventory Item using QODBC? 
How do I insert data into ItemNonInventory? 
How do I insert data into ItemOtherCharge table? How do I create a Other Charge item? 
How do I create a Item Assembly (ItemInventoryAssembly)? 
How do I insert data into ItemService? 
How do I create Item Groups(ItemGroup)? 

and: Can I get some examples of how to use QODBC via Visual Basic?