Hi Mohammed
Never SET FILTER using object.property values. If the object (or form) goes away or goes out of scope, the filter will fail. Also filter is slower with property values. Use constants via macro substitution or memory variables.
>hi all,
>
> i need to change this statments to somthing more activeate
>(without error message filter cleared).
>
>SELECT mstr
>LOCATE FOR BILLNO=THISFORM.TEXT1.VALUE .AND. DATEIN=THISFORM.TEXT2.VALUE
>IF FOUND()
>SET FILTER TO BILLNO=THISFORM.TEXT1.VALUE .AND. DATEIN=THISFORM.TEXT2.VALUE
>
>
>
>thanks
>
>m.qasem