>>CREATE CURSOR TARGET (pk_field i, task_no n(6,0), week_fr n(6,0), week_to n(6,0), week_no n(6,0), employee c(10) ) >>INSERT INTO TARGET (pk_field, task_no, week_fr, week_to, week_no, employee ) VALUES ; >> (1, 10, 1, 52, 4, '') >>INSERT INTO TARGET (pk_field, task_no, week_fr, week_to, week_no, employee ) VALUES ; >> (2, 10, 1, 52, 4, '') >>INSERT INTO TARGET (pk_field, task_no, week_fr, week_to, week_no, employee ) VALUES ; >> (3, 10, 1, 52, 4, '') >> >>SELECT TARGET >>INDEX ON pk_field TAG pk_field >>SET ORDER TO TAG pk_field >> >>*-- create SOURCE cursor >>CREATE CURSOR SOURCE (pk_field i, task_no n(6,0), week_fr n(6,0), week_to n(6,0), week_no n(6,0), employee c(10) ) >> >>INSERT INTO SOURCE (pk_field, task_no, week_fr, week_to, week_no, employee ) VALUES ; >> (5, 10, 1, 52, 4, '') >>INSERT INTO SOURCE (pk_field, task_no, week_fr, week_to, week_no, employee ) VALUES ; >> (2, 10, 1, 52, 23, '') >> >>SELECT TARGET >>SET RELATION TO PK_FIELD INTO SOURCE >>GO TOP >>replace week_no WITH SOURCE.week_no, week_fr WITH SOURCE.week_fr, week_to WITH SOURCE.week_to all >>
>REPLACE ALL week_no WITH SOURCE.week_no, week_fr WITH SOURCE.week_fr, week_to WITH SOURCE.week_to FOR NOT EOF('source') >>
>>BROWSE TITLE "TARGET after update" >>>>