Thanks Razzak - those feature and your tips are all very helpful. R:Base just keeps on getting better.
Thank you. Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Monday, 2 September 2013 4:00 p.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Tip of the Day: Enhanced DB Grid Search, Filter, Hide, andSort Features 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. ================================================
