Skip to Content
0
Former Member
Jun 02, 2008 at 04:07 PM

Transfer Routine updates wrong...Need a quick solution.

17 Views

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.