hi all,
any idea.
my table has field (flag) i insert 1,2...3 you can see 10 records have flage 1,20 records has flage 2 etc....
i need to get 5 records from evry flag to insert to anther table hase the same filds.
i'll try with code but the gode get all records
SELECT 1
USE aliq
m.no=no
m.nam=nam
DO WHILE .t. and no=m.no
skip
IF m.no<>no
m.no=no
IF EOF()
EXIT
ENDIF
endif
enddo
thanks
m.qasem