>The scan below is not running
>
>SELECT email_anexo
>
> SCAN
>
> thisform.refresh
> LOCATE FOR emails.cod = email_anexo.id
>
> IF FOUND()
> replace email_anexo.spam with .F.
> ELSE
> replace email_anexo.spam with .T.
> ENDIF
>
> ENDSCAN
Why do you need SCAN?
replace spam with (NOT email_anexo.id == emails.cod) IN email_anexo
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.