|
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
|
|
| Error Creating Header XML on this table in BuildXMLHeader |
| Author |
Message |
|
|
| Posted : 2006-12-07 04:09:14 |
When i insert customer values i get this error in QODBCLOG FILE
IsAService: False
SQL Statement: INSERT INTO "Customer" ("Name","IsActive","CompanyName","Salutation","FirstName","LastName","BillAddressAddr1","BillAddressAddr2",
"BillAddressAddr3","BillAddressAddr4","BillAddressCity","BillAddressState","BillAddressPostalCode","BillAddressCountry
","ShipAddressAddr1","ShipAddressAddr2","ShipAddressAddr3","ShipAddressAddr4","ShipAddressCity",
"ShipAddressState","ShipAddressPostalCode","ShipAddressCountry","Phone","Fax","Email") VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Error Creating Header XML on this table in BuildXMLHeader
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<QBXML>
<QBXMLMsgsRq responseData="includeAll" onError="continueOnError">
<CustomerAddRq requestID="1">
<CustomerAdd>
</CustomerAdd>
</CustomerAddRq>
</QBXMLMsgsRq>
</QBXML>
Can anybody help me with this as soon as possible with thanks. |
|
| |
Abdul Rahim Khan
Idealcomputing co. Ltd. Edinburgh Scotland, UK.
|
| | Top | |
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-12-07 11:49:58 |
There's no data in your log item. But I just retested this statement using the Sample Rock Castle Construction company file and QuickBooks 2006 Premier Edition (USA version) with QODBC v7.00.00.199 without any errors:
insert into customer (name, firstname, lastname, companyName, contact, accountNumber, BillAddressAddr1, BillAddressAddr2,
BillAddressAddr3, BillAddressCity, BillAddressState, BillAddressPostalCode, Phone, Fax, Email,
TermsRefListID, SalesTaxCodeRefListID, PreferredPaymentMethodRefFullName, CreditCardInfoCreditCardNumber,
CreditCardInfoExpirationMonth, CreditCardInfoExpirationYear, CreditCardInfoNameOnCard,
CreditCardInfoCreditCardAddress, CreditCardInfoCreditCardPostalCode, JobStatus,
JobStartDate, JobEndDate, JobDesc)
values ('Joe Mama Inc 5', 'Joe', 'Mama', 'Joe Mama Inc 5', 'Joe Mama', '343453', 'Joe Mama Inc', '123 Main St.',
'Suite 456', 'Chicago', 'IL', '60602', '555-555-5555', '666-666-6666', 'joe@mama.com',
'10000-933272658', '10000-999022286', 'Visa', '4111111111111111', 06, 2008, 'Joe Mama',
'123 Main St. Suite 450', '60707', 'None', {d'2006-05-11'}, null, '$39.95 Monthly Subscription - Bill CC Monthly')
Try debugging your SQL Statement using VB Demo. |
|
|
|
|
