Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement