At 07:21 PM 9/3/2013, Dan Goldberg wrote:
I have a form with an enhanced dbgrid. How would a user enter something
in the filter bar to bring up null results for that column?
Dan,
Here's how ...
01. Start R:BASE eXtreme 9.5
02. CONNECT dbname
03. Database Explorer | Forms ...
Open the form in form designer
04. While in Form Designer, right-click on Enhanced DB Grid control
Enhanced DB Grid control | Object Property | Columns ...
Select the column and click on [Column Properties] button
05. Enhanced DB Grid Column Properties | Filter ...
Select Type as "Column Values"
06. Save form and close the form designer
07. Run the form
http://www.razzak.com/tips/Enhanced_DBGrid_Filters_01.jpg
08. Click on the column filter drop-down list and notice the
distinct column values, including "<Empty>".
http://www.razzak.com/tips/Enhanced_DBGrid_Filters_02.jpg
09. Select "<Empty>" from the list for NULL rows
http://www.razzak.com/tips/Enhanced_DBGrid_Filters_03.jpg
Notice the filtered rows with only empty (NULL) column values
That's all there is to it!
If you need a quick tutorial to illustrate this cool feature, let
me know and I will send you an invite. http://join.me/RazzakMemon
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
30+ years of continuous innovation!
15 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
