|
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
|
|
| QBOE Select from RecievePayment problem |
| Author |
Message |
|
|
| Posted : 2008-08-19 02:38:54 |
I am using the QODBC Driver to connect to QuickBooks Online Edition and get the data on the payments that were made from the last time that I run the program.
I am trying to run the next SQL statement: "SELECT * FROM ReceivePayment WHERE TxnNumber > 20530". When I run this statement in VB Demo program I get the table headers of ReceivePayment table and no data. I checked the Review QODBC Messages and got this message:
2008-08-18 11:50:39 QODBC Ver: 8.00.00.243 *********************************************************************************************************************
IsAService: False
SQL Statement: SELECT * FROM "ReceivePayment" CALLDIRECT
Error Getting XML in BuildAndLoadXMLForNextRecord
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE QBXML PUBLIC '-//INTUIT//DTD QBXML QBO 6.0//EN' 'http://apps.quickbooks.com/dtds/qbxmlops60.dtd'>
<QBXML>
<SignonMsgsRq>
<SignonTicketRq requestID="0">
<ClientDateTime>2008-08-18T11:50:09</ClientDateTime>
<SessionTicket>V1-87-Iig3_Y2C9A7fijd1sLZNfw:127257129</SessionTicket>
<Language>English</Language>
<AppID>71271511</AppID>
<AppVer>1.0</AppVer>
</SignonTicketRq>
</SignonMsgsRq>
<QBXMLMsgsRq onError="continueOnError">
<ReceivePaymentQueryRq requestID="1">
<MaxReturned>00000500</MaxReturned>
</ReceivePaymentQueryRq>
</QBXMLMsgsRq>
</QBXML>
I also tried running the SQL statement with calldirectly option, with optimizer turned off and got the same message with just the SQL statement line in the message changed.
Is there a way to get the data that I need. |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-08-19 07:49:51 |
When over 1000 records could be returned by any given query by the QuickBooks Online Edition (QBOE), the query get's terminated by QBOE at the Intuit end. Assuming that you are looking at payments since January this year, you need to query a smaller subset of records like this:
Select * from ReceivePayment UNOPTIMIZED WHERE Txndate > {d '2008-01-01'}
Where the date format is {d 'YYYY-MM-DD'}
You can also remove the UNOPTIMIZED (or CALDIRECT) tag if it works as I've only added it to bypass your local optimized tables in case there's something wrong there. You should always use the QODBC Optimizer with using QBOE.
|
|
|
|
|