>Hi All,
>
>Sometimes I see that with select-sql queries (.DBF file queries); query empty but recc()#0. I never saw that with foxpro dos. I recently realized that and I don't use if recc()=0 for find empty queries (I use a blank locate and found() ).
>
>Why that occurs?
>
>I'm not sure but with one of my .dbf file when I delete my binary index I saw that problem being disappeared.
Please see
http://berezniker.com/display/VFP/Queries+and+Filtered+Cursors for detailed explanation.
If it's not broken, fix it until it is.
My Blog