Remove FROM clause. It's needed when you want to join to some other table.
>UPDATE: The _TALLY is working. ALL the records are getting updated, but they do NOT match the WHERE clause. The variables are today's date and the table contains various date values.
>
>Why would the _TALLY for this be 41 (all the records in the table) if there isn't one match to the WHERE clause? There are no records with the field values of the m.DOSBegin and m.DOSEnd variables. And, nothing seems to be updated, as it should be. But what's with the _TALLY value?
>
> UPDATE EligAct SET ;
> ActStatus = ALLTRIM(m.ActStatus) ;
> ActDate = DATE(), ;
> ActType = 'On Demand' ;
> FROM EligAct ;
> WHERE ;
> EligAct.PatNum = THISFORM.txtPat_No ;
> AND EligAct.DOSBegin = m.DOSBegin ;
> AND EligAct.DOSEnd = m.DOSEnd
> IF _TALLY = 0
>
--sb--
