>Hello all
> i have a table ,i want to delete a limited number of records after i make
>filter .e.i if have team_no=4 ,when i make filter to this team_no i got 100 records ,i want to delete 25 record or 40 etc....
>
>i write set filter to team_no=4 how i can make filter to 25 frm 100 etc....
I think you mean how to set filter not delete.
thisform.addproperty('aFiltered[1]',0)
select top 25 ;
recno() as rcno ;
from myTable ;
where team_no = 4 ;
order by 1 ;
into array thisform.aFiltered
set filter to ascan(thisform.aFiltered, recno()) > 0
Cetin