Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Browse bug??
Message
From
07/06/2007 13:21:24
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
07/06/2007 02:23:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01231066
Message ID:
01231375
Views:
14
>I can not see what causes your problem, but I have a few advices:
>1. Avoid SET FILTER whenever possible, instead you can use "BROWSE FOR yourcondition"

BROWSE FOR is equal to SET FILTER. What are you referring to?

>2. Don't use GO TOP after SET FILTER, instead use LOCATE which in many cases is extremely much faster

That's for sure!

>
>>I have been having trouble lately with a browse command causing a shift in the current work area. For example:
>>
>>
>>set filter to PermID == lcPermID and (LoCWW > 7 or HiCWW > 7 or LoCWWHrs > 24 or HiCWWHrs > 24)
>>go top
>>if ! eof()
>>	messagebox("The following records need to be corrected for CWW > 7 or CWWHrs > 24. ")
>>	browse && shows table1
>>endif
>>set filter to
>>
>>brow title 'Get ready'   && shows table2
>>set filter to PermID == lcPermID and upper(valid) = "NO"
>>go top
>>
>>I can't imagine what's causing this unless my installation has become corrupted somehow. Has anyone else ever experienced this? This is happening throughout my application in various routines and prg's.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform