I do now and it works - Thank you Dan!
I also like using column_name vs number.
Doug
On 10/3/2018 8:39 AM, Dan Goldberg wrote:
Do you have this checked?
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,
visithttp://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
torbase-l+unsubscr...@googlegroups.com
<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visithttps://groups.google.com/d/optout.
--
For group guidelines,
visithttp://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 torbase-l+unsubscr...@googlegroups.com
<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visithttps://groups.google.com/d/optout.
--
For group guidelines,
visithttp://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 torbase-l+unsubscr...@googlegroups.com
<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visithttps://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://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
<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.
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
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.
