Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid filter
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Divers
Thread ID:
01220283
Message ID:
01220289
Vues:
23
Hi Moises,

Are you sure you want to use FILTER? Perhaps other solutions would be better.

In any case, don't use form's properties as you do, because you're looking for trouble this way.
lcValue = thisform.text1.value
lcFilter = 'field = [' + m.lcValue + ']'
set filter to &lcFilter
locate
thisform.grid1.refresh()
Still it would be better to run a select statement based on your criteria, zap the grid's cursor and insert from the temp cursor.

>Whenever I apply the filter below by a button click event,
>the filter works
>
>However, the user has to scroll up the grid so he can se all records
>that matches that creteria
>Sometimes the user forgets to scrow up, because only one item appears,
>but surely there are more items above (hidden)
>
>How can I do so more records appears on the whole grid
>
>*********************************************************
>SET FILTER TO UPPER(ALLTRIM(TEL)) = UPPER(alltrim(thisform.pageframe1.page1.text1.value))
>
>THISFORM.REFRESH
>*********************************************************
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform