Hi All,
I have an issue, when I load the name, it loads the name to other records where the TODATE is not the date I am checking. However when I check the routine in debug mode the code works perfect, but after that the name is there in all records even the DATETO is in the past.
SELECT SINGLE TXTMD
INTO mname
FROM /BIC/TZBUSEMP
WHERE /BIC/ZBUSEMP = TRAN_STRUCTURE-EMPLOYEE AND
DATETO = '99991231'.
though I have the DATE RANGE is specific it update the name for all records? How can I avoid this?
Thanks,
Alex.