I used to run my queries like this:

select * from table into cursor XXX nofilter
select XXX
if _tally=0
messagebox('No data found!')
else
report form YYY preview
endif

Lately, I started to get the message even if my cursor has lines and I had to change it to the following way:

select xxx
ntotal=reccount()
if ntotal=0...

I have the problem with query that worked well till now, what's happening?
Thank you for answer
PS
When I try to get the _tally value I get 0 (even with lines in the cursor).