Monday, September 2, 2013
Tip of the Day: Enhanced DB Grid Search, Filter, Hide, and Sort Features
Product.: R:BASE eXtreme 9.5 (32/64)
Build...: 9.5.3.20829 or higher www.rupdates.com
Keywords: Forms, Enhanced DB Grid, Commands, Hot Keys
When running an Enhanced DB Grid, did you know that the "Select
Column(s) for Sort"
dialog, to performing multi-column sorting, can now be launched using
the PROPERTY
command, in addition the hot keys [Ctrl+D]?
A new PROPERTY command parameter has been introduced to launch the
"Select Column(s)
for Sort" dialog from a command file or EEP.
PROPERTY <Component ID> SHOWSORTDIALOG 'TRUE'
In all, several features have been added to the Enhanced DB Grid
control to allow
advanced searching, filtering, column hiding, and multi-column
sorting for the grid
records. Several dialogs can be launched using hot keys or by using
the PROPERTY
command.
01. Record Searches
The Enhanced DB Grid supports "Record Search" capabilities that can be launched
while running the form.
http://www.razzak.com/Tips/EnhancedDBGrid_Search.jpg
Hot Keys..: [Ctrl + F]
Syntax....: PROPERTY <Component ID> SHOWFINDDIALOG 'TRUE'
A progress dialog will be displayed during the search process, so the
user knows the
search is working.
http://www.razzak.com/Tips/EnhancedDBGrid_SearchDialog.jpg
02. Filter Setup
The Enhanced DB Grid allows a filter to be created to limit the
displayed rows, with
many available conditions for specific results.
http://www.razzak.com/Tips/EnhancedDBGrid_FilterSetupNew.jpg
Hot Keys..: [Ctrl + L]
Syntax....: PROPERTY <Component ID> SHOWFILTERDIALOG 'TRUE'
After the "Filter Setup" is launched and conditions are selected for
the Enhanced DB
Grid, the GETPROPERTY command can be used to return the current
filter as a WHERE
Clause. This is helpful if the current record set needs captured for
export, report
output, or used elsewhere.
GETPROPERTY TABLE TableName->FILTEREDWHERE vVarName
03. Show/Hide Columns
The columns headers of the Enhanced DB Grid can be hidden/displayed
and rearranged.
The check boxes control whether a column is displayed. The arrow buttons on the
dialog are used to possibly reorder the columns.
http://www.razzak.com/Tips/EnhancedDBGrid_ColumnSetup.jpg
Hot Keys..: [Ctrl + S]
Syntax....: PROPERTY <Component ID> SHOWCOLUMNDIALOG 'TRUE'
04. Multi-Column Sorting
One or more of the Enhanced DB Grid columns can be sorted in either
ascending or
descending order.
http://www.razzak.com/Tips/SortColumns.jpg
Hot Keys..: [Ctrl + D]
Syntax....: PROPERTY <Component ID> SHOWSORTDIALOG 'TRUE'
05. To set the focus/cursor directly in a filter field for an Enhanced DB Grid
Syntax....: PROPERTY <Component ID> FOCUSONFILTERBAR 'TRUE/FALSE'
06. To clear filter(s) all at once
Syntax....: PROPERTY <Component ID> CLEARFILTER 'TRUE'
Stay productive, my friends!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
www.RazzakMemon.com
--
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.
================================================
