Morning Richard, I have a form that contains a variable radio group that sets filters similar to what you're doing. Using the on Click I use the following
IF vfilter = 'all' THEN PROPERTY fflist LOOKUPWHERECLAUSE 'where pond_id is not null' GOTO cleanup ENDIF In your case I would think the where statement would be "is null". This shows the option as being selected. Hope it helps On Thu, Nov 30, 2023 at 7:53 AM 'R Hopkins' via RBASE-L < [email protected]> wrote: > Hopefully, one of you has solved this puzzle before. > > I am using a form that contains only one Variable Radio Group property one > Enhanced DB Grid properties. The value selected in the Variable Radio Group > property is used to filter the values in a column in the Enhanced DB Grid > property with a LIKE comparison. Here are the details, with an example. > > The Variable Radio Group property contains 4 selections: "Bill", "Sam", > "Will", "All". Upon clicking any one of these selections, the Variable > Radio Group's Value is loaded into a variable. The Caption and the Value > (which becomes the value in the variable of type TEXT) are the same, except > for "All", which is NULL (no value entered on the property tab). For the > Enhanced DB Grid property, the Filter Type is LIKE, and the column filtered > is FullName. > > This form works as desired. Selecting any Caption properly filters the > rows displayed, and selecting "All" results in all rows in the table being > displayed. My problem is cosmetic. When the Caption "All" is selected, > the word "All" gets a box drawn around it, like any other selection, but > unlike the other selections, its radio button does not fill in. This > happens because the Value for this selection is NULL. > > I have tried substituting the following wildcard values for NULL; "%", > "_". But when used in the LIKE comparator, no rows are displayed instead > of all rows being displayed. Using " " (a single space), all rows are > displayed, but the radio button does not fill - behaves the same as using > NULL. > > Interestingly, using the comparable command at the R> yields an error. > SET VAR vValue TEXT = NULL > BROWSE * FROM TableName WHERE FullName LIKE .vValue > -ERROR - Nulls cannot be used in comparisons other than NE or EQ (2315) > BROWSE * FROM TableName WHERE FullName LIKE &vValue > <WARNING> No rows exist or satisfy the specified clause. (2059) > Whereas the following displays all rows without an error message > SET VAR vValue TEXT = '%' > BROWSE * FROM TableName WHERE FullName LIKE .vValue > > Anyone have any tricks for what value I should put in the Value field of > the Variable Radio Group for the "All" caption to make it display all rows > AND fill in the button? Is this something I should report as a bug (after > all, a box does get drawn around the word "All" when it is selected)? > > Richard Hopkins > > -- > 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]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/175052776.5218885.1701294805381%40mail.yahoo.com > <https://groups.google.com/d/msgid/rbase-l/175052776.5218885.1701294805381%40mail.yahoo.com?utm_medium=email&utm_source=footer> > . > -- Regards Tony -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABnhDATs6m1A_s9zkcjNxErQa88puKUa-06tunAF9w0LKNaSWg%40mail.gmail.com.
