>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).

Chaim,

Do you've any commands between SELECT INTO CURSOR and IF _TALLY=0 that could rest _TALLY to 0? What's VFP version?