Knowledgebase: Tutorials
[QODBC-Desktop] Troubleshooting - How to stop any query on VB Demo Application
Posted by Jack - QODBC Support on 10 March 2016 12:34 PM

Troubleshooting - How to stop any query on VB Demo Application

Problem Description:

How to Stop any query on VBDEMO when it takes time.

How to convert the date to QuickBooks date.

I want to insert TxnDate in the ReceivePayment table, but it pops up the operator and operand error.

I am just inserting values in ReceivePayment Table. My Query is:

INSERT INTO ReceivePayment (CustomerRefListID, ARAccountRefListID,txndate,RefNumber, PaymentMethodRefFullName,Memo, DepositToAccountRefListID, TotalAmount,IsAutoApply) VALUES ('B480000-1171302186', '3C0000-1164634404','2007-02-12','10667','SECPAY','72465', '80000-1164634403',54.04, TRUE)

I am looking for your early reply with thanks.
 

Solution:

You can stop query execution by clicking "Stop Query" from QODBC Icon on the system tray. Right click on QODBC Icon in the system tray and click on "Stop Query" and 5 or 10 minutes.



If above does not work and you need to close VB Demo, use Alt-Ctrl-Del and the Windows Task Manager to end the VB Demo application task:





QODBC uses the standard SQL date format: {d'YYYY-MM-DD'}, You will get Invalid operand for operator error when you provide wrong data type values in your query. Please refer Troubleshooting - [QODBC] Invalid operand for operator

INSERT INTO ReceivePayment (CustomerRefListID, ARAccountRefListID,txndate,RefNumber, PaymentMethodRefFullName,Memo, DepositToAccountRefListID, TotalAmount,IsAutoApply) VALUES ('B480000-1171302186', '3C0000-1164634404', {d'2007-02-12'},'10667','SECPAY','72465', '80000-1164634403',54.04, TRUE)

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).