Skip to main content

Uniface 9: big problem with date fields[U9.4]

  • November 19, 2018
  • 3 replies
  • 0 views
Jan Cees Boogaard

big problem with date fields[U9.4]

Author: spanish_uniface@hotmail.es (uniface8)

Hi all, i have a big problem with datefields; we have stored in our database fielddates with format '0001-01-01 00:00:00.000000' but U9.4 not recognize that as a date format, so when i retrieve that fields, uniface returns only zeros '00000000'.

Is there any parameter to modificate that?

I mean, i know that i can control that with a few lines of code, but we have thousands of forms, any other solution will be great.

Regards,Rafa.

    3 replies

    Jan Cees Boogaard

    big problem with date fields[U9.4]

    Author: spanish_uniface@hotmail.es (uniface8)

    Hi all, i have a big problem with datefields; we have stored in our database fielddates with format '0001-01-01 00:00:00.000000' but U9.4 not recognize that as a date format, so when i retrieve that fields, uniface returns only zeros '00000000'.

    Is there any parameter to modificate that?

    I mean, i know that i can control that with a few lines of code, but we have thousands of forms, any other solution will be great.

    Regards,Rafa.

    Have a look at the different options you have defining the Interface of the date-field in your data model.

    Beside the simple "D" you have a couple of variations (D1 ... D8 ..)

    Think your problem is solved by entering the "best-match" Date-option.

    Success, Uli


    Author: ulrich-merkel (ulrichmerkel@web.de)
    Jan Cees Boogaard

    big problem with date fields[U9.4]

    Author: spanish_uniface@hotmail.es (uniface8)

    Hi all, i have a big problem with datefields; we have stored in our database fielddates with format '0001-01-01 00:00:00.000000' but U9.4 not recognize that as a date format, so when i retrieve that fields, uniface returns only zeros '00000000'.

    Is there any parameter to modificate that?

    I mean, i know that i can control that with a few lines of code, but we have thousands of forms, any other solution will be great.

    Regards,Rafa.

    Thanks Uli, our datefield is E8 (it´s combined date and time), I think is right, but I test different options.

    Regards,Rafa.


    Author: uniface8 (spanish_uniface@hotmail.es)
    Jan Cees Boogaard

    big problem with date fields[U9.4]

    Author: spanish_uniface@hotmail.es (uniface8)

    Hi all, i have a big problem with datefields; we have stored in our database fielddates with format '0001-01-01 00:00:00.000000' but U9.4 not recognize that as a date format, so when i retrieve that fields, uniface returns only zeros '00000000'.

    Is there any parameter to modificate that?

    I mean, i know that i can control that with a few lines of code, but we have thousands of forms, any other solution will be great.

    Regards,Rafa.

    Hi,

     

    I havn't test it, but have a look at the dbms-parameters, e.g. oracle

    USYS$ORA_PARAMS = use_timestamp

    Maybe this helps.

    Best regards

    Thomas


    Author: Thomas.Young (thomas.young@young-consulting.de)

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement