Hi Mohammed,

first of all, you must put the USE lines outside the loop!!

>hi all,
>
>i want to delete record from table1=record form tabel2
>
>i'll try with this code, it delete the first top record only,
>
>

>CLOSE all
>DO WHILE .t.
>  SELECT 1
>   USE ali
>     m.char3=char3
>  SELECT 2
>   USE ali123
>    LOCATE for ali123.char3=m.char3
>       IF FOUND()
>        DELETE
>
>         SELECT 1
>         skip
>           IF EOF()
>             EXIT
>           ENDIF
>      endif
>enddo
>