The column number is zero based. It is the column in the grid 3 would be the 4th column from the left in the grid. I think the “REFRESH” is not needed, and might cancel the FILTER statement. (Wild Guess)
Albert > On Oct 3, 2018, at 7:32 AM, Doug Hamilton <bugl...@wi.rr.com> wrote: > > Need help please. > I can't get FILTERS to work. > Is the nnn column number the number of the column in the table or on the grid? > Is the column number zero based? > I've tried all permutations of the above, with and without quotes around the > FILTERS [NNN]->VALUE. > > I 'm using a new form with only an enhanced DB grid, comp ID cidSHPIGrid > (SHPI isn't a typo) and a pusbutton with this code: > > SET MESSAGE ON > SET ERROR MESSAGE ON > SET TRACE ON > > PROPERTY cidSHPIGrid FILTERS[3]->VALUE 'UPAC' > > PROPERTY cidSHPIGrid REFRESH 'TRUE' > > SET TRACE OFF > SET MESSAGE OFF > SET ERROR MESSAGE OFF > RETURN > > Running the code produces no change in the grid, no messages. > Are there any DB Grid Options that should or should not be checked? > Any other settings required or shouldn't be selected? > And, yes, UPAC is a existing text value in the column. > RB XE, 10913. > > TIA > DOUG > > On 10/2/2018 10:31 AM, Albert Berry wrote: >> I just had a look in R:Docs X >> >> PROPERTY <Component ID> 'FILTERS[NNN]->VALUE' ‘Filter_Vaue' >> >> Changes the filter value on the Enhanced DB Grid column, where nnn is the >> column number. >> >> Example: >> >> PROPERTY EnhDBGrid FILTERS[2]->VALUE 'CA' >> PROPERTY EnhDBGrid FILTERS[2]->VALUE '' >> >> Albert >> >> >>> On Oct 1, 2018, at 3:30 PM, Dan Goldberg <d...@lancecamper.com >>> <mailto:d...@lancecamper.com>> wrote: >>> >>> Thx but I just tried it and no change. >>> >>> Dan Goldberg >>> >>> From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> >>> <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>> On Behalf Of >>> Albert Berry >>> Sent: Monday, October 1, 2018 2:25 PM >>> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> >>> Subject: Re: [RBASE-L] - Enhanced db grid - refresh filter >>> >>> Have you tried POSTing the table before REFRESH? >>> >>> >>> >>> On Oct 1, 2018, at 3:13 PM, Dan Goldberg <d...@lancecamper.com >>> <mailto:d...@lancecamper.com>> wrote: >>> >>> I have an enhanced db grid with a filter turned on. >>> >>> <image001.png> >>> >>> If I change the value to the row and save it, I want the filter to add it >>> to the list. >>> >>> <image002.png> >>> >>> So if I change the value of “App Status in a row to “X” and save it, the >>> drop down should now include “X” but doesn’t. >>> >>> I have tried table refresh and it doesn’t show. Does anyone know how to >>> recalculate the filter? >>> >>> TIA >>> >>> Dan Goldberg >>> >>> >>> -- >>> For group guidelines, visit >>> http://www.rbase.com/support/usersgroup_guidelines.php >>> <http://www.rbase.com/support/usersgroup_guidelines.php> >>> --- >>> You received this message because you are subscribed to the Google Groups >>> "RBASE-L" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to rbase-l+unsubscr...@googlegroups.com >>> <mailto:rbase-l+unsubscr...@googlegroups.com>. >>> For more options, visit https://groups.google.com/d/optout >>> <https://groups.google.com/d/optout>. >>> >>> -- >>> For group guidelines, visit >>> http://www.rbase.com/support/usersgroup_guidelines.php >>> <http://www.rbase.com/support/usersgroup_guidelines.php> >>> --- >>> You received this message because you are subscribed to the Google Groups >>> "RBASE-L" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to rbase-l+unsubscr...@googlegroups.com >>> <mailto:rbase-l+unsubscr...@googlegroups.com>. >>> For more options, visit https://groups.google.com/d/optout >>> <https://groups.google.com/d/optout>. >>> >>> -- >>> For group guidelines, visit >>> http://www.rbase.com/support/usersgroup_guidelines.php >>> <http://www.rbase.com/support/usersgroup_guidelines.php> >>> --- >>> You received this message because you are subscribed to the Google Groups >>> "RBASE-L" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to rbase-l+unsubscr...@googlegroups.com >>> <mailto:rbase-l+unsubscr...@googlegroups.com>. >>> For more options, visit https://groups.google.com/d/optout >>> <https://groups.google.com/d/optout>. >> >> -- >> For group guidelines, visit >> http://www.rbase.com/support/usersgroup_guidelines.php >> <http://www.rbase.com/support/usersgroup_guidelines.php> >> --- >> You received this message because you are subscribed to the Google Groups >> "RBASE-L" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to rbase-l+unsubscr...@googlegroups.com >> <mailto:rbase-l+unsubscr...@googlegroups.com>. >> For more options, visit https://groups.google.com/d/optout >> <https://groups.google.com/d/optout>. > > > > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon> > Virus-free. www.avast.com > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link> > <x-msg://1/#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rbase-l+unsubscr...@googlegroups.com > <mailto:rbase-l+unsubscr...@googlegroups.com>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.