General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I read your article. It's clearly tells issue...
I used optimized queries with dos but I used them just for reports. I used seek and locate for record lookups and do-while for other things (reused old foxbase codes)...
>The problem existed since SQL Queries (and filtered cursors) were introduced in FoxPro 2.0. I guess you never wrote optimized queries in Fox 2.x. You should use _TALLY system variable for local cursors to determine number of records returned.
>
>>
>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only