FarPoint Forums

The FarPoint Message Boards
Welcome to FarPoint Forums Sign in | Join | Help
in Search

currency error

Last post 07-07-2008, 4:54 PM by scotts. 23 replies.
Page 1 of 2 (24 items)   1 2 Next >
Sort Posts: Previous Next
  •  06-29-2007, 5:56 AM 48450

    currency error

    Attachment: example.rar
    Hello, I'm from spain.

    I'm testing your component (and I have found 2 bugs)  and I have found another one (i think so).

    Correct Format:
    Spain (and Europe): 3.456,77
    Usa: 3,456.77

    When I input the value 2500 the component show me (at focus lost) 2.500.00. It seems that put the 2 decimal with the integer value.

    ¿What it's wrong? ¿is it another bug?

    Here you have an example with the other case in study.
  •  06-29-2007, 8:17 AM 48454 in reply to 48450

    Re: currency error

    By default the control has 2 decimal places.  If you set CurrencyDecimalPlaces to 0 the it will show 2500.

    Bob M.
    FarPoint Technologies, Inc.
  •  06-29-2007, 9:17 AM 48459 in reply to 48454

    Re: currency error

    Yes, I know but it seems that the error occurs when de control is binding to a data field.
    Try it


    P.S: I have reported another bug (http://www.clubfarpoint.com/Forums/forums/48422/ShowThread.aspx#48422). Are they relationated? Is it an error?
  •  06-29-2007, 9:47 AM 48464 in reply to 48459

    Re: currency error

    I created an access database and set the field data type to currency and set the decimal places to 0 for it and the control and the $2500 shows up w/o decimal places.

    Bob M.
    FarPoint Technologies, Inc.
  •  06-29-2007, 11:05 AM 48474 in reply to 48464

    Re: currency error

    Attachment: example.rar
    Then....what's wrong in this example?
  •  06-29-2007, 11:41 AM 48485 in reply to 48474

    Re: currency error

    You have the CurrencyDecimalPlaces set to 2 and your database has DecimalPlaces set to Auto, so it's going to show two decimal places.

    Bob M.
    FarPoint Technologies, Inc.
  •  06-29-2007, 12:08 PM 48489 in reply to 48485

    Re: currency error

    Here you have a good example. Please, test it. There are problems at isvalid propertry (sometimes doesn't fire).
    Make it a hard test!

  •  06-29-2007, 12:32 PM 48493 in reply to 48489

    Re: currency error

    What is it you are wanting to me to test?  Do you have an example?

    Bob M.
    FarPoint Technologies, Inc.
  •  06-29-2007, 1:15 PM 48495 in reply to 48493

    Re: currency error

    Attachment: example.rar
    i have attached to this post and with de last.

    ¿Do you have an email o IM to comunicate and post here the solutions to others?
  •  06-29-2007, 1:45 PM 48497 in reply to 48495

    Re: currency error

    I have tested your example, but as I said you have CurrencyDecimalPlaces set to 2 and to Auto in your database so it's going to show 2 decimal places.  What else do you need to have tested?

    Bob M.
    FarPoint Technologies, Inc.
  •  06-29-2007, 1:57 PM 48499 in reply to 48497

    Re: currency error

    No, the mdb has 2 (no auto) in decimal places in field money.
    Then, when I input only 55.88(USA format) ( 55,88 europe format) the field show me 5.588,00 (5,588.00 Usa format).

    Please, can you set your windows regional preferences to spanish. Perhaps with these settings you will reproduce the error.

    ¿Do you have any temporary msn o something similar?
  •  06-29-2007, 2:12 PM 48501 in reply to 48499

    Re: currency error

    Attachment: decimals.JPG
    The mdb had DecimalPlaces set to auto and the currency control had 2 decimal places set.  I changed them both to 0 and the attachment shows what I see with those changes and regional set to Spanish.

    Bob M.
    FarPoint Technologies, Inc.
  •  06-29-2007, 2:34 PM 48503 in reply to 48501

    Re: currency error

    Attachment: STEP 1.rar
    Here you have screenshots of the error. Please, I'm not "crazy", but I see you are not reproducing it.

    Do you have enoght information. Do you need anything else?

    Take a view to the ms word document attached and you see the problem (I hope so! )



  •  06-29-2007, 3:07 PM 48505 in reply to 48503

    Re: currency error

    I think you are misunderstanding how the control works when you are changing the value.  Let's say I have the 88,85 value from the mdb database in the control when I run your project.  If I then change the value to 55,88 without arrowing into the decimal section then it would display 55.88,00.  You would have to type the 55 and then arrow over and type the 88 so the value would read  55,88.

    Bob M.
    FarPoint Technologies, Inc.
  •  06-29-2007, 3:40 PM 48507 in reply to 48505

    Re: currency error

    No, think I understand the control.
    I type 1111,88 and in the field appears 1.111,88 (correct), but, when i exit the field show 111.158,00 (incorrect). The control has modified the decimal number and puts zeros in decimal and the decimal value to the integer. Have you see de word document of the last post? Do you have msn messenger? Here is very slow to work.
Page 1 of 2 (24 items)   1 2 Next >
View as RSS news feed in XML
     FarPoint Forums Home