Hi Unifacers ,
We recently Patched/Updated Oracle to 19.14.0.0.220118 for some reason and now, retrieving using $date(Fieldname) has stopped working.
Uniface version 9.6.06.01 (1125_1)
After some investigating, here's what we've noticed.
(This retrieve has stopped working)
clear/e "ent1"
date_field.ent1 = $date(date_field.Ent2)
Retrieve/e "ent1"
error -2,
->hits 0
(In debug, it generates a where clause "where (date_field.ent1 = 11052022 00:00:00)
(Work around-same data)
So I moved the profile to the read trigger.
read where "date_field = '%%$date(date_field.ent2)"
->hits 1
happy days :)
(In debug, the generated where clause (where date_field.ent1 = '11-may-2022')
Is there a patch we need to install on uniface and if so, where do I find it,
or is there a setting like $NLS_DATE_UNIFACE_PARSER (which I've tried, but no joy).
Rather than work around the issue, we prefer to fix the issue.
Thank you in advance for your help.
Stanley
------------------------------
Stanley Odukoya
Software Engineer
Rocket Forum Shared Account
------------------------------