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
|
|
How to stop any query on VBDEMO Application |
Author |
Message |
|
Posted : 2007-02-20 00:16:05 |
Hello Tom, How to Stop any query on VBDEMO when it takes time. How to convert date into QBdate.
I want to insert txndate in ReceivePayment table ; but it pop up the operator and operand <assignment> 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.
Thanks. |
|
|
Abdul Rahim Khan
Idealcomputing co. Ltd. Edinburgh Scotland, UK. |
| Top | |
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-02-20 08:37:20 |
If 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'}, ie:
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)" |
|
|
|
|
Posted : 2007-02-20 22:35:52 |
Hello Tom, Thanks for your help. I sometime received the error in quickbook saying that some application is still using the quickbook. I have even shut down the application using qodbc but it still doesnot allow the quickbook to logoff.
Can you please tell me what i have to do to allow quickbook to properly shut down. As, i know it is b/c of the qodbc application which was closed but still not allowing quickbook to logoff.
What you suggest to make sure that quickbook will logoff properly and exit in nice manner.
I am looking ahead for your kind reply with thanks. |
|
|
Abdul Rahim Khan
Idealcomputing co. Ltd. Edinburgh Scotland, UK. |
| Top | |
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-02-20 23:04:11 |
Closing applications, that use QODBC, that work through Windows Services doesn't close the connection. Often services will hold the connection open and it can take the Windows O/S ten minutes or so to close the connection. If your application submits invalid operations to QODBC, the driver can crash and leave the connection open in memory and you will need to close QuickBooks using the Windows Task Manager.
Please also make sure you're running QODBC v7.00.00.207 (or higher) as I've had shutdown problems with 199 and 204. |
|
|
|
|