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.
