Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Setting SFQuery filter
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Divers
Thread ID:
00264572
Message ID:
00264594
Vues:
20
You could add a property to your form, say icSiteFilter, and set that in THISFORM.INIT(). Then:

WITH THISFORM
.oQuery.SHOW()

lcFilter = .icSiteFilter

IF !EMPTY( .oQuery.cFilter )
lcFilter + " AND " + .oQuery.cFilter
ENDIF

SET FILTER TO &lcFilter

.REFRESH()
ENDWITH

>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
Chris McCandless
Red Sky Software
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform