|
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
|
|
| Problem with using a comma to separate decimals |
| Author |
Message |
|
|
| Posted : 2007-02-01 06:55:20 |
Hi,
I just bougth your software QODBC, much of it seems to work well, but I get this issue, and I can't seems to resolve it.
For the background information, I live in Canada, I speek French, my date format starts by the day, followed by the month and then the year. I also use comma to separate the decimals, and no dots in numbers.
I can't to create an invoice (the MAIN reason why I bought the software).
Here's what I do:
Query:
SELECT "CustomerRefListID", "RefNumber",
"InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate",
"InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefListID" FROM "InvoiceLine" WHERE RefNumber = 'PRG0001'
Result :
1 20000-0 PRG0001 40000-2147475117 Semaine du 14 au 18 mars 2005 50,00.00000 1200,00.00 10000-0
2 20000-0 PRG0001 40000-2147475117 Semaine du 21 au 25 mars 2005 50,00.00000 1770,00.00 10000-0
3 20000-0 PRG0001 B0000-2147475117 2970,00.00
4 20000-0 PRG0001 10000-2147475117 TPS 86309 3183 RT0001 207,90.00 10000-0
5 20000-0 PRG0001 B0000-2147475117 3177,90.00
6 20000-0 PRG0001 A0000-2147475117 1208646121 TQ0001 238,34.00 20000-0
See how the number are weirds...
Now I try this insert command:
INSERT INTO InvoiceLine ("CustomerRefListID", "RefNumber",
"InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate",
"InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefListID") VALUES (
'20000-0', 'PRG0099', '40000-2147475117', 'Semaine du 14 au 18 mars 2005', '50,00.00000', '1200,00.00', '10000-0')
I get Invalid operand for operator: <assignment>
And this is no better:
INSERT INTO InvoiceLine ("CustomerRefListID", "RefNumber",
"InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate",
"InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefListID") VALUES (
'20000-0', 'PRG0099', '40000-2147475117', 'Semaine du 14 au 18 mars 2005', '50', '1200', '10000-0')
BUT, with this:
INSERT INTO InvoiceLine ("CustomerRefListID", "RefNumber",
"InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate",
"InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefListID") VALUES (
'20000-0', 'PRG0999', '40000-2147475117', 'Semaine du 14 au 18 mars 2005', 50, 1200, '10000-0')
I get:
Error:3040 - There was an error when converting the amount "1200.00" in the field "item amount". QuickBook error message: This field contains an invalid character.
I get a sense all of this comes from the added dot in "1200.00", that should be a comma.
What sould I do? Of course, I also need to add decimal numbers.
TIA,
Antoine Raymond-Beaubien
Services de programmation Beaubien
antoine@beaubien.qc.ca
(514) 996-8399 |
|
| |
Services de programmation Beaubien
(514) 996-8399
antoine@beaubien.qc.ca
|
| | Top | |
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-02-01 09:17:25 |
Sorry, QODBC currently only supports the use of a . (fullstop) as the decimal symbol in the Regional Settings of Windows.
|
|
|
|
|