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
|
|
Invoice Number E+11 |
Author |
Message |
|
Posted : 2008-08-31 01:39:37 |
INSERT INTO InvoiceLine (CustomerRefFullName, TxnDate, RefNumber, PONumber, IsToBePrinted, InvoiceLineItemRefFullName, InvoiceLineDesc,InvoiceLineQuantity,InvoiceLineRate,FQSaveToCache......
Everything works fine except the RefNumber. The RefNumber inserted : '0004' inserted as E+11 '0808080125' inserted as 2.008E+11
Started tests with no records in InvoiceLine.
I'm using Visual Foxpro. |
|
|
QODBC Desktop Read Write 2007 Asia Pacific Version 8.00.00.242
(upgrade to 9.00.00.250 @20080927)
(upgrade to 9.00.00.253 @20081125)
(downgrade to 8.00.00.242 @20081126)
Quickbooks Premier 2007/2008 Asia Edition (Malaysia) |
| Top | |
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-09-01 00:08:36 |
Sorry, but you didn't supply the full SQL Statement, I really need to see how the values were built in the statment? |
|
|
|
|
Posted : 2008-09-01 00:44:52 |
Ooooops....I thought sufficient to recomend a solution.
My bad, forgot to test using the VB demo provides. The demo works fine. Tested statement that works :
INSERT INTO INVOICELINE CustomerRefFullName,RefNumber,InvoiceLineItemRefFullName,InvoiceLineDesc,InvoiceLineQuantity,InvoiceLineRate,FQSaveToCache) VALUES ('UPJ','0808080004','WS','ASPHALTIC WEARING COURSE',23,165,1) INSERT INTO INVOICELINE (CustomerRefFullName,RefNumber,InvoiceLineItemRefFullName,InvoiceLineDesc,InvoiceLineQuantity,InvoiceLineRate,FQSaveToCache) VALUES ('UPJ','0808080004','WS','ASPHALTIC WEARING COURSE',21,165,1) INSERT INTO INVOICELINE (CustomerRefFullName,RefNumber,InvoiceLineItemRefFullName,InvoiceLineDesc,InvoiceLineQuantity,InvoiceLineRate,FQSaveToCache) VALUES ('UPJ','0808080004','WS','ASPHALTIC WEARING COURSE',24.5,165,0) AND MY FOXPRO SQL STATEMENT DOESN'T. AND NOT IN ANY WAY CAUSED BY QODBC. MY FOXPRO STATEMENT IS WRONG, THE VALUE SENT WAS "2.008e+11" and not 0808080125 as stated earlier.
My bad, sorry! |
|
|
QODBC Desktop Read Write 2007 Asia Pacific Version 8.00.00.242
(upgrade to 9.00.00.250 @20080927)
(upgrade to 9.00.00.253 @20081125)
(downgrade to 8.00.00.242 @20081126)
Quickbooks Premier 2007/2008 Asia Edition (Malaysia) |
| Top | |
|
|
|