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 Comments
Local Administrator
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)
Local Administrator
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)
Local Administrator
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)