>>>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
>>
>
>Do you want REPLACE ALL here?
Did I?
No, but the code want it (or at least what I think the code want)
Stay aside of the EOF status when the MAIL is NOT found.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.