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
---
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.
