Hi Khubaib,

The SELECT SQL generates a result cursor which by default is aliased as "Query". To avoid displaying the browse on query, include INTO CURSOR youralias in your SELECT sql statement, which will generate the result query into youralias cursor.
HTH

>

Set Filter To code=thisform.code.value
> Set Order To month1
> LOCATE

>
>
>i try
>

>SELECT Acctran.code;
> FROM ;
>     acctran;
> WHERE  Acctran.month1 = (thisform.month1.value);
> ORDER BY Acctran.month1
>

>
>when i convert in sql (query) i get a brows. How avoid the brows i want only filter and order by sql