Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Insert into Item table |
Author |
Message |
|
Posted : 2006-11-29 01:47:10 |
It says in the table definition for the "Item" table that there are no insertable fields:
http://www.qodbc.com/docs/html/qodbc/20/tables/table_detail_us.asp?details_id=109&tn_us=TRUE
When I link a table from access and open the table then try to manually insert records, I am unable to create a new record and I can do it with other linked tables...
What I did next is create a new item record with quickbooks, then I opened the link table in access and tried to manually insert a record that is identical to the record I created in quickbooks (except the name is slightly modified) ...it didn't work.
If I can't do a manual insert with a linked table, how is it going to work with code? I know the linked table works because it displays data when I open it in access... |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-11-29 12:59:19 |
The ITEM table is a combined (read only view) list of all Item tables in QuickBooks: ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, and ItemGroup; with minimum common fields.
Inserts and updates are actually done using the ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, or ItemGroup tables.
See: How do I add a Inventory Item using QODBC? How do I insert data into ItemService? How do I insert data into ItemNonInventory? How do I create a Item Assembly (ItemInventoryAssembly)? for more. |
|
|
|
|
Posted : 2006-11-29 13:15:34 |
greetings
what I found out is i was able to insert into the itemservice table which updated the item table
all is well
cheers
scott
|
|
|
|
|