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 : Invoice Insert IssuesSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC SQL Support Forum

 New Topic 
 
 Post Reply 
[1]  
 Invoice Insert Issues 
 Author   Message 
  Jack Nichols 
  
 Group: Members 
 Posts: 14 
 Joined: 2006-06-01 
 Profile
 Posted : 2006-06-30 00:44:18

Below are two insert statements that return an error: "There is a missing element: TxnID" These inserts work fine on a different QB database file ... what gives? 

INSERT INTO InvoiceLine (CustomerRefFullName, ClassRefFullName, TemplateRefFullName, BillAddressAddr1, BillAddressAddr2, BillAddressCity, BillAddressState, BillAddressCountry, ShipDate, InvoiceLineItemRefFullName, InvoiceLineDesc, InvoiceLineQuantity, InvoiceLineSalesTaxCodeRefFullName, FQSaveToCache, CustomFieldreferral) VALUES ('Abbas Aida', 'Class Name', 'DMK Medical PLLC', '', '', '', '', '', {d'2006-06-29'}, 'Procedures Facial:Platysmaplasty - Short Flap', 'Platysmaplasty - Short Flap', 1, 'Non', 1, '17')

INSERT INTO InvoiceLine (CustomerRefFullName, ClassRefFullName, TemplateRefFullName, BillAddressAddr1, BillAddressAddr2, BillAddressCity, BillAddressState, BillAddressCountry, ShipDate, InvoiceLineItemRefFullName, InvoiceLineDesc, InvoiceLineQuantity, InvoiceLineSalesTaxCodeRefFullName, FQSaveToCache, CustomFieldreferral) VALUES ('Abbas Aida', 'Class Name', 'DMK Medical PLLC', '', '', '', '', '', {d'2006-06-29'}, 'Procedures Facial:Lifestyle Lift', 'Lifestyle Lift', 1, 'Non', 0, '17')

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-06-30 08:56:39

I suggest you turn on the trace log and see what the actual error is. Most likely one of the FullName references isn't valid for the company file you're working with.

See: How do I turn on the trace log? 

You should also check if there's a difference in your Use Case Sensitive RefNumber Searches setting.

Use Case Sensitive RefNumber Searches when checked means a refnumber of 'ABC' and 'abc' will be different, but means QuickBooks can use an index internally for a search instead of a complete table scan. (Note: this feature applies to versions of QuickBooks 2005 and higher)

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to