As Borislav wrote, avoid using alltrim unless you really need it, which means almost NEVER!

>Scan is scanning only one record of table ap
>I mean, it's not scanning all the table until the final
>I wonder which command lines will cause trouble to scan
>
>
>USE AP
> SCAN
>
>rAp = RECNO()
>
>USE ap_control
>
>COUNT for ALLTRIM (AP.CL) = ALLTRIM(AP_CONTROL.CL) .and. ALLTRIM (AP.AP) = ALLTRIM(AP_CONTROL.AP);
>.and. ALLTRIM(ap.marca) = alltrim(ap_control.marca) .and. ALLTRIM(ap.modelo) = ALLTRIM(ap_control.modelo) TO ap_find
>
>IF ap_find = 0
>
> = MESSAGEBOX ("Not_found")
>
>APPEND FROM ap FOR RECNO() = rAp
>
> ELSE
>
>
> = MESSAGEBOX ("Found")
>
>
> ENDIF
> endscan