Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Empty query but recc()#0
Message
From
23/11/2007 09:07:18
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01270868
Message ID:
01270874
Views:
14
Thank you for solution, It had made me crazy!.. :)

>Hi Metin,
>
>Because VFP use DBF and set only filter...
>
>Use keyword NOFILTER - see to help.
>
>MartinaJ
>
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform