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
|
|
system can't execute command |
Author |
Message |
SLS |
|
Group | : Members |
Posts | : 11 |
Joined | : 2008-01-30 |
|
Profile |
|
Posted : 2008-11-18 06:16:42 |
I have an Access database that uses Union statments to pull data. We're using the new ODBC driver, 9.00.00.253.
Where I'm stumped is that the report works fine except for one data file. (Of course the one I need it for.) I can run the report on sample files from the same location or different locations and it works fine. I've tried other "real" QuickBooks files, they run fiine. I get a message that the system can't execute the command whenever I try it on the "real" file that I need though. I've tried deleting the .opt file. I've run a verify and rebuild on the QB file, still it won't work.
What else could it be? How can a query work with all but 1 file? I've check setting, I'm signed in as Admin....PLEASE HELP!!!
Stacy |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-11-18 10:46:18 |
Please look at the bottom of the QODBC Messages Log from the QODBC Setup Screen Messages Tab and post the SQL statement and the real error. |
|
|
|
SLS |
|
Group | : Members |
Posts | : 11 |
Joined | : 2008-01-30 |
|
Profile |
|
Posted : 2008-11-20 03:37:37 |
Below is the log from trying to run it thet other day. I never learned what the log really did...guess I should huh?! So, could the transaction that it calls out at the end of it be damaged? I would attach the full SQL, but as you can see from what's in the log, it's a bit much. After that one Select Statment there are 9 Union statments about as long. (No, I did not write this, just tried cleaning it up a bit.) If you still need the entire thing is there a different way to get it to you, email?
Thanks for all your help. It is appreciated. Stacy
2008-11-17 13:23:48 QODBC Ver: 9.00.00.253 ********************************************************************************************************************* IsAService: Unknown LOADXML Problem Parsing Error: 0 - \
2008-11-17 13:23:48 QODBC Ver: 9.00.00.253 ********************************************************************************************************************* IsAService: False SQL Statement: SELECT "BillExpenseLine"."ExpenseLineCustomerRefFullName" ,"BillExpenseLine"."VendorRefFullName" ,"Transaction"."TxnType" ,"BillExpenseLine"."TxnDate" , "BillExpenseLine"."RefNumber" ,"BillExpenseLine"."ExpenseLineMemo" ,"BillExpenseLine"."ExpenseLine AccountRefFullName" ,"BillExpenseLine"."ExpenseLineAmount" FROM "BillExpenseLine","Account","Transaction" WHERE (((NOT(("BillExpenseLine"."ExpenseLineCustomerRefFullName" = '' ) ) AND ("BillExpenseLine"."ExpenseLineAccountRefListID" = "Account"."ListID" ) ) AND ((NOT(("Account"."AccountType" = 'AccountsPayable' ) ) AND NOT(("Account"."AccountType" = 'AccountsReceivable' ) ) ) AND NOT(("Account"."AccountType" = 'Income' ) ) ) ) AND ("BillExpenseLine"."TxnID" = "Transaction"."TxnID" ) ) GROUP BY "BillExpenseLine"."ExpenseLineCustomerRefFullName" ,"BillExpenseLine"."VendorRefFullName" ,"Transaction"."TxnType" ,"BillExpenseLine"."TxnDate" , "BillExpenseLine"."RefNumber" , "BillExpenseLine"."ExpenseLineMemo" ,"BillExpenseLine"."ExpenseLineAccount RefFullName" ,"BillExpenseLine"."ExpenseLineAmount" Error In LoadXML in BuildAndLoadXMLForNextRecord Input XML: <?xml version="1.0" ?> <QBXML> <QBXMLMsgsRs> <TransactionQueryRs requestID="1" statusCode="0" statusSeverity="Info" statusMessage="Status OK"> <TransactionRet> <TxnType>Bill</TxnType> <TxnID>840-1034603954</TxnID> </TransactionRet> </TransactionQueryRs> </QBXMLMsgsRs> </QBXML> |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-11-20 09:23:59 |
Sorry the SQL Statement is a mess, this works:-
SELECT "BillExpenseLine"."ExpenseLineCustomerRefFullName" ,"BillExpenseLine"."VendorRefFullName" , "Transaction"."TxnType" ,"BillExpenseLine"."TxnDate" ,"BillExpenseLine"."RefNumber" ,"BillExpenseLine"."ExpenseLineMemo", "BillExpenseLine"."ExpenseLineAccountRefFullName" ,"BillExpenseLine"."ExpenseLineAmount" FROM "BillExpenseLine","Account","Transaction" WHERE "BillExpenseLine"."TxnID" = "Transaction"."TxnID" AND "BillExpenseLine"."ExpenseLineAccountRefListID" = "Account"."ListID" AND "BillExpenseLine"."ExpenseLineCustomerRefFullName" is not null AND "Account"."AccountType" <> 'AccountsPayable' AND "Account"."AccountType" <> 'AccountsReceivable' AND "Account"."AccountType" <> 'Income' GROUP BY "BillExpenseLine"."ExpenseLineCustomerRefFullName" , "BillExpenseLine"."VendorRefFullName" ,"Transaction"."TxnType" , "BillExpenseLine"."TxnDate" ,"BillExpenseLine"."RefNumber" , "BillExpenseLine"."ExpenseLineMemo" ,"BillExpenseLine"."ExpenseLineAccountRefFullName" , "BillExpenseLine"."ExpenseLineAmount" |
|
|
|
|