Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Working of if command
Message
From
18/07/2009 05:57:05
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01412935
Message ID:
01413165
Views:
55
>What is banifit of nofilter in my this query. what is diffidence use nofilter and not use.

You must add Nofilter or Readwrite if you want to create a "real" cursor, if you don't VFP will simply use the From table and set a filter to it. The way VFP behaves is very efficient, but it may cause serious problems when you want to use this cursor later. That's why they added the Nofilter clause which forces VFP to create a new cursor. Readwrite makes the new cursor updateable, and also makes the keyword Nofilter redundant.

From your code I guess that you simply want to check how many, if any at all, matches the criteria you specify, and in that case I suggest that you specify that the end result goes into an array. And as I wrote in another message, Reccount() will not always give you the correct number of records, use _tally insetad.
Previous
Reply
Map
View

Click here to load this message in the networking platform