>Hi,
>
>Could someone, please, explain why I am getting an error. What I am doing is updating from one cursor to another.
>The SQL Update that works is as follows:
>

>Update (tcCursorName) set week_no = S.week_no, week_fr = S.MON_WK_FR, week_to = S.MON_WK_TO ;
>	 from (tcBatchUpdCursor) S where EVALUATE(tcCursorName + ".TASK_NO") = S.TASK_NO 
>

>No problem above.
>
>But when I add to the WHERE clause another condition, I get error "Object PM_SCHED is not found" The PM_SCHED is the value of the tcCursorName (that cursor that is being updated)
>
>

>Update (tcCursorName) set week_no = S.week_no, week_fr = S.MON_WK_FR, week_to = S.MON_WK_TO ;
>	 from (tcBatchUpdCursor) S where EVALUATE(tcCursorName + ".TASK_NO") = S.TASK_NO 
>        AND EVALUATE( tcCursorName + ".eqpmsch.pk" ) > 0
>

>
>What am I dong wrong in the second SQL Update?
>
>TIA

If the last clause of the WHERE is referencing a column in tcCursorName, the expression has two dots, which is not allowed. Maybe it should be

AND EVALUATE( tcCursorName + ".eqpmsch_pk" ) > 0