Skip to main content

Uniface 10 gives different result by putting date in string field

  • June 16, 2021
  • 2 replies
  • 1 view
R

Uniface 10 gives different result by putting date in string field

$string$ = "%%$string$%%%3;"    

$string$ = "%%$string$%%RCO_DT_BOEKING.REKCOUR%%%;"


In uniface 9.7  on Windows server 2012 this results that $string$ is filled with  "3;15-03-2021;"

In uniface  10.3 on Windows server 2016 this results that $string$ is filled with  "3;15-mar-2021;"

The date format now gives an issue in the following process since the string has an fixed length.


The windows lanquage and date/time setting are checked on both servers and set the same. 

the field RCO_DT_BOEKING.REKCOUR has as display format DIS(dd-mm-jjjj)

    2 replies

    R

    Uniface 10 gives different result by putting date in string field

    $string$ = "%%$string$%%%3;"    

    $string$ = "%%$string$%%RCO_DT_BOEKING.REKCOUR%%%;"


    In uniface 9.7  on Windows server 2012 this results that $string$ is filled with  "3;15-03-2021;"

    In uniface  10.3 on Windows server 2016 this results that $string$ is filled with  "3;15-mar-2021;"

    The date format now gives an issue in the following process since the string has an fixed length.


    The windows lanquage and date/time setting are checked on both servers and set the same. 

    the field RCO_DT_BOEKING.REKCOUR has as display format DIS(dd-mm-jjjj)

    We solved it by installing the latest patch

    Ingo Stiller
    Forum|alt.badge.img+3
    • Ingo Stiller
    • Participating Frequently
    • June 17, 2021

    Uniface 10 gives different result by putting date in string field

    $string$ = "%%$string$%%%3;"    

    $string$ = "%%$string$%%RCO_DT_BOEKING.REKCOUR%%%;"


    In uniface 9.7  on Windows server 2012 this results that $string$ is filled with  "3;15-03-2021;"

    In uniface  10.3 on Windows server 2016 this results that $string$ is filled with  "3;15-mar-2021;"

    The date format now gives an issue in the following process since the string has an fixed length.


    The windows lanquage and date/time setting are checked on both servers and set the same. 

    the field RCO_DT_BOEKING.REKCOUR has as display format DIS(dd-mm-jjjj)

    Hi Richard

    WTF: "since the string has an fixed length" 🙂
    Yes, we still have code with similar approach (shame on us), but ... 
    But a better solution ist to use UnifAce itemlist

    $string$ = ""
    $string$ = "%%$string$%%%3°;"
    $string$ = "%%$string$%%RCO_DT_BOEKING.REKCOUR%%%°;"
    ;where °; is GOLD-;

    Then you access to the date part by
    $1 = $itemnr(2,$string$)

    Just an idea to avoid such problems in the future ..

    Ingo

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement