Do you have this checked? [cid:[email protected]] 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: [email protected] <[email protected]> On Behalf Of Doug Hamilton Sent: Wednesday, October 3, 2018 6:33 AM To: [email protected] 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 <[email protected]<mailto:[email protected]>> wrote: Thx but I just tried it and no change. Dan Goldberg From: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> On Behalf Of Albert Berry Sent: Monday, October 1, 2018 2:25 PM To: [email protected]<mailto:[email protected]> 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 <[email protected]<mailto:[email protected]>> 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 [email protected]<mailto:[email protected]>. 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 [email protected]<mailto:[email protected]>. 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 [email protected]<mailto:[email protected]>. 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 [email protected]<mailto:[email protected]>. 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 [email protected]<mailto:[email protected]>. 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
