Do you have this checked? [cid:image001.png@01D45AE3.CB8BA670] Also, the number is 0 based, so column 3 is the fourth column.
This is one that works for me. Approvalstatus is the column name and vappstatus is a variable. I use column name instead. PROPERTY EnhancedDBGrid2 FILTERS->COLUMN_NAME->ApprovalStatus .vappstatus Dan Goldberg From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Doug Hamilton Sent: Wednesday, October 3, 2018 6:33 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Enhanced db grid - refresh filter 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 --- 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. -- 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<mailto:rbase-l+unsubscr...@googlegroups.com>. For more options, visit 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<mailto:rbase-l+unsubscr...@googlegroups.com>. For more options, visit 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<mailto:rbase-l+unsubscr...@googlegroups.com>. For more options, visit https://groups.google.com/d/optout. [https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif]<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> -- 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<mailto:rbase-l+unsubscr...@googlegroups.com>. For more options, visit 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.