|
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
|
|
| I am getting "Run-time error '3450' Syntax error in query. Incomplete query clause" |
| Author |
Message |
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-02-17 22:23:51 |
I am getting "Run-time error '3450' Syntax error in query. Incomplete query clause" using Visual Basic when doing the following VendorCreditItemLine sample file insert:
INSERT INTO "VendorCreditItemLine"
("VendorRefListID", "APAccountRefFullName", "TxnDate", "RefNumber", "Memo",
"itemlineitemreffullname", "ItemLineDesc", "ItemLineQuantity", "ItemLineCost", "ItemLineAmount",
"ItemLineTaxCodeReffullname", "FQSaveToCache") VALUES ('200000-1045537156', 'Accounts Payable',
{d'2006-01-30'}, '93079', 'Memo Test', 'Door', 'Front Entrance Door', 3.00, 3.33, 9.99,'GST', 0) |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-02-17 22:25:00 |
A review of the QB SDK Message log found within the QODBC Setup screen showed the 'ExpenseLineAdd' was not valid for content model:
20060130.145810 I 1360 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 2676).
20060130.145810 E 1360 XercesSAXErrorHandler Element 'ExpenseLineAdd' is not valid for content model: '(VendorRef,APAccountRef?,TxnDate?,RefNumber?,Memo?,ExpenseLineAdd*,((ItemLineAdd|ItemGroupLineAdd))*,Tax1Total?,Tax2Total?,ExchangeRate?,AmountIncludesVAT?)' -- error at line 7, column 478 in XML data.
20060130.145810 I 1360 MsgSetHandler Parser error, finishing.
20060130.145810 I 1360 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 2676), ret = 1.
20060130.145810 E 2676 RequestProcessor Process Request error = 80042500, There was an error when parsing the provided XML file.
20060130.150133 I 2676 RequestProcessor Connection closed by app named 'FLEXquarters QODBC'
20060130.150133 I 2676 RequestProcessor ========== Ended Connection ==========
While a review of the actual QODBC Message log found within the QODBC Setup screen only showed Error parsing complete XML return string.
2006-01-30 14:58:10 QODBC Ver: 6.00.00.143 *********************************************************************************************************************
IsAService: False
SQL Statement: INSERT INTO "VendorCreditItemLine" ("VendorRefListID", "APAccountRefFullName", "TxnDate", "RefNumber", "Memo", "itemlineitemreffullname", "ItemLineDesc", "ItemLineQuantity", "ItemLineCost", "ItemLineAmount", "ItemLineTaxCodeReffullname", "FQSaveToCache") VALUES ('200000-1045537156', 'Accounts Payable', {d'2006-01-30'}, '93079', 'Memo Test', 'Door', 'Front Entrance Door', 3.00, 3.33, 9.99,'GST', 0)
Error parsing complete XML return string (8)
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="AU3.0"?>
<QBXML>
<QBXMLMsgsRq onError = "continueOnError" responseData = "includeAll">
<VendorCreditAddRq requestID = "1">
<VendorCreditAdd defMacro = "TxnID:56742C25-E2F2-41B0-8489-BD73C62B06D4">
<VendorRef>
<ListID>200000-1045537156</ListID>
</VendorRef>
<APAccountRef>
<FullName>Accounts Payable</FullName>
</APAccountRef>
<TxnDate>2006-01-30</TxnDate>
<RefNumber>93079</RefNumber>
<Memo>Memo Test</Memo>
<ItemLineAdd>
<ItemRef>
<FullName>Door</FullName>
</ItemRef>
<Desc>Front Entrance Door</Desc>
<Quantity>3.00000</Quantity>
<Cost>3.33000</Cost>
<Amount>9.99</Amount>
</ItemLineAdd>
<ExpenseLineAdd>
<TaxCodeRef>
<FullName>GST</FullName>
</TaxCodeRef>
</ExpenseLineAdd>
</VendorCreditAdd>
</VendorCreditAddRq>
</QBXMLMsgsRq>
</QBXML>
The 'ExpenseLineAdd' was not valid for content model: has been identified as a QODBC product defect and has been rectified in QODBC v6.0.0.147 (Build 147) and above.
Region Affected: All Australian, New Zealand and Asia Pacific sites
Release Affected: All QODBC v5 releases and v6.0.0.143 or earlier
Please update your QODBC installation to our most current release.
|
|
|
|
|