marco
|
| Posted: 11/05/2002, 7:51 PM |
|
Hi,
We are using international currency and see some problems. I am not sure if it is in CC or in the server.
Problem:
Adding a new record - you can type a number with .: 123.45
After saving and update you will see: 123,45
after saving it is now 12345.
Questions:
Why is it with a new record . and updating a record ,
Any suggestion show to solve this in cc?
Regards,
Marco
|
|
|
 |
EMG
|
| Posted: 11/06/2002, 1:53 PM |
|
sounds like a data type issue in your database. make sure you are using a currency, float or double data type for the column.
|
|
|
|
Nicole
|
| Posted: 11/09/2002, 2:34 AM |
|
Marco,
Most probably it depends on national server settings. What you can do is to find out what national settings are used and apply format number function to the value before inserting it to db and before displaying it on the form in order to convert value into desired national format.
The functions to use depends on programming language.
|
|
|
|
marco
|
| Posted: 11/09/2002, 7:57 AM |
|
Hi,
We have tested 3 hours and do know the problem in CC.
Before we did had problems with both us , uk and nl server currency/decimal notations. While clients are nl.
First adding a new record all was wokring correct. Updating does give problems, while the grid shows an other currency display.
The solution:
In the before show event of both the grid and the record page/form you should add a statement: fldCurrency = formatNumber (fldCurrency,2)
It seems that without this you will have sometime problems, on server/cients.
Regards,
Marco
|
|
|
|
feha
|
| Posted: 11/09/2002, 9:36 AM |
|
When you define price column in database define it as DECIMAL (example: format 10,2 ) not as INT (INTEGER).
regards
feha
www.vision.to
|
|
|
|
|
