hi Charlie,
Thanks for reply.

I just tried it, no luck.
It very strange, even when I run a small program with if statement and scan the table, still it finds only 4 recirds, but When I do a filter in the command window, it finds 16 records.



even this program finds only 4 records.

select 0
use course order cid

select 0
use semester order cid

select 0
use enroll order cstudent
x = 0
set relation to ccourse into course
set relation to csemester into semester additive
GO TOP
Go Bottom
scan
if cstudent = "QÛ06÷3FVT" and semester.cid = "R£06ñbç00"
x= x + 1
endif
endscan
messagebox(str(x))