Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

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

Forum : I can read a file, but I get errors when I try to edit/delete/create records?Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Frequently Asked Questions

 New Topic 
 
 Post Reply 
 I can read a file, but I get errors when I try to edit/delete/create records? 
 Author   Message 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-02-25 20:46:54

First make sure your user rights are setup and not restricted to read only in QuickBooks or your network software.

You can delete records from QuickBooks, but you must be in single-user mode using the QuickBooks company file. Also, QuickBooks must allow you to delete records - see our Schema document for details on each file to see if it is possible to delete records from it.

In addition, certain tables have child records that must be saved at the same time as the parent or header record. The child tables are listed below following the name of the parent table:

Bill: BillExpenseLine, BillItemLine, BillLinkedTxn
Invoice: InvoiceLine, InvoiceLinkedTxn
Check: CheckExpenseLine, CheckItemLine
CreditCardCharge: CreditCardChargeExpenseLine, CreditCardChargeItemLine
CreditCardCredit: CreditCardCreditExpenseLine, CreditCardCreditItemLine
CreditMemo: CreditMemoLinkedTxn, CreditMemoLine
Host: HostSupportedVersions
Estimate: EstimateLine
ItemGroup: ItemGroupLine
ItemSalesTaxGroup: ItemSalesTaxGroupLine
JournalEntry: JournalEntryDebitLine, JournalEntryCreditLine
PurchaseOrder: PurchaseOrderLine
ReceivePayment: ReceivePaymentLine
SalesReceipt: SalesReceiptLine
VendorCredit: VendorCreditExpenseLine, VendorCreditItemLine, VendorCreditPaymentLine

 

  Top 
 New Topic 
 
 Post Reply 

Jump to