>>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
>

I was just about to delete my post and admit my typo when you saw it. Thank you.
I was getting the object error and I didn't even think of looking at all spellings. My bad.