1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

How to coverts character to decimal in progress 4GL?

Discussão em 'StackOverflow' iniciado por fdantas, Abril 19, 2019.

  1. fdantas

    fdantas Administrator Moderador

    I have written a query to show character as decimal value but i got an error. Let me share

    DEFINE VARIABLE cDateTime AS CHARACTER NO-UNDO.

    DEFINE TEMP-TABLE tt_data NO-UNDO
    FIELD DateTime AS DECIMAL FORMAT "->>,>>9.99".

    ASSIGN
    cDateTime = "20191604121566".

    CREATE tt_data.
    ASSIGN
    tt_data.DateTime = DECIMAL(cDateTime) /* Message Date and Time */



    But its says "Value cannot be displayed using ->>>,>>>,>>9.999999". Could you please help this case and tell me what is the wrong here?

    Continue reading...

Compartilhe esta Página