Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting SFQuery filter
Message
General information
Forum:
Visual FoxPro
Category:
Stonefield
Miscellaneous
Thread ID:
00264572
Message ID:
00264790
Views:
18
>On my form, I have "Set Filter" button that has the following code:
>
>with thisform
> .oQuery.show()
> lcFilter=.oQuery.cFilter
> set filter to &lcFilter
> .refresh()
>endwith
>
>The DE for this form has a table that has a filter always set based on the site the user choose when opening the application. Ex. Inventory.SiteID==gnSiteID.
>
>How can I append the current filter to the filer statement returned form oQuery?
>
>Thanks
>Kirk

How about....
local lcOrigFilt
lcOrigFilter = Set('Filter')

with thisform
	.oQuery.show()
	lcFilter=.oQuery.cFilter
	set filter to (&lcOrrigFilter) and (&lcFilter)
        locate  &&I think you need this to activate the filter
	.refresh()
endwith

* to cancel the filter to the orig do this...
set filter to &lcOrigFilter
locate
BOb
Previous
Reply
Map
View

Click here to load this message in the networking platform