Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfp50 - SET FILTER - can not BROWSE
Message
From
06/04/1997 10:36:16
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
01/04/1997 09:26:19
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00025702
Message ID:
00027186
Views:
49
>>>>>How come I can not BROWSE when I SET FILTER TO something?
>>>>
>>>>I just set up a dummy table in VFP5 with a field called test2 (a 10 position charactor field). I populated several records with some 1's, 2's and 3,s. I then entered the command "SET FILTER TO TEST2='1'" and only the records with the 1's appeared in the browse Unless there is something I am not seeing it your question , check the expressions on both sides of the = sign (or other operator). I usually check this mysely by going to a record where I think I know what the result would be and enter a command similar to the one in the filter command such as this.
>>>>
>>>>? TEST2='1'
>>>>
>>>>if you have constructed the statement correctly it should return .t.
>>>
>>>The part that does not work is when I call BROWSE FIELDS. The error message is THIS IS NOT AN OBJECT IN THE FORM. Brow_calls is a method
>>>in the parent class.
>>>help?
>>
>>You will have to provide some more code for any of us to figure out your problem. Both the browse command and the filter would be nice Also, try to avoid using SET FILTER and grids.
>>
>>Thanks
>>Mike Yearwood, Toronto, Ontario Canada (co-founder of the Toronto Foxpro User's Group)
>
>Hi Mike... I found my problem. My ControlSource was set to
>table->fld. It is now set to fld.
>
>Why should I avoid using SET FILTER and grids?
>
>thanks...Rob

Build a table with 150,000 records field1 is numeric and is set equal to the record number. set filter to inlist(field1,37500,75000,112500) and start a form with a grid. Before any one jumps in to comment that inlist is not Rushmore optimized, forget it you're wrong!) 3-4 minutes later you'll see your form and be able to start data entry. Again most will tell you to use a view. If your filter is changed to extract 10,000 records, the view will take long also.

Mike
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform