Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set Filter issues
Message
 
To
18/04/2017 09:00:51
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Miscellaneous
Thread ID:
01650326
Message ID:
01650327
Views:
50
>Hi
>
>I have a form with a grid which has a RecordSourced to a local table/DBF. I have an input field which I want to allow a user to enter some text in and then use that text to SET FILTER on the table for a field containing that entered text.
>
>The form loads and the entire table contents is displayed in the grid. I enter some text in the field and click a button which applies a SET FILTER TO instruction. The table is refreshed and correctly displays the filtered data. This is so far OK.
>
>But when I now click on the table, for example in the vertical scroll bar, some strange things happen; (1) a small VFP window appears saying "Filter cleared" and then (2) the entire form re-loads! Indeed, every time I repeat this process it reloads another copy of the form as soon as I click anywhere on the grid.
>
>The grid parent itself has no code associated with it. The contained columns, which have text controls, have DBLClick and InteractiveChange method code. But this happens even when I only click in the grid's scrollbar.
>
>Anyone can suggest what I am doing wrong here?

Hi Jos,

What is filter expression?

MartinaJ
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform