Thank you, Albert.
That's very helpful - and you're correct - I took out the refresh.
I had it in 'cuz nothing seemed to be working.
Doug
On 10/3/2018 10:21 AM, Albert Berry wrote:
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 <[email protected]
<mailto:[email protected]>> 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 <[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,
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 [email protected]
<mailto:[email protected]>.
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 [email protected]
<mailto:[email protected]>.
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 [email protected]
<mailto:[email protected]>.
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 [email protected]
<mailto:[email protected]>.
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>
<x-msg://1/#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
--
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.
---
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
