Monday, December 16, 2013
Tip of the Day: Using Enhanced DB Grid Sort Column Properties
Product.: R:BASE eXtreme 9.5 (32/64)
Build...: 9.5.3.21205 or higher www.rupdates.com
Keywords: Enhanced DB Grid, Column Sort
Section.: Form Controls
Did you know that you can sort the Enhanced DB Grid Columns without
clicking on the actual column header, using the PROPERTY commands?
New PROPERTY commands have been implemented in the latest updates
and builds of R:BASE eXtreme 9.5 (32/64).
Here's how:
-- Syntax
PROPERTY <EnhancedDBGridComponentID> SortAsc '0'
PROPERTY <EnhancedDBGridComponentID> SortDesc '0'
-- Examples (Based on RBG9_EnhancDBGrd form included with RRBYW18)
-- To Dynamically Sort (ASC) the first column (Company)
PROPERTY DBGrid_Customers SortAsc '0'
-- To Dynamically Sort (DESC) the first column (Company)
PROPERTY DBGrid_Customers SortDesc '0'
-- To Dynamically Sort (ASC) the second column (City)
PROPERTY DBGrid_Customers SortAsc '1'
-- To Dynamically Sort (DESC) the second column (City)
PROPERTY DBGrid_Customers SortDesc '1'
Alternative, you could also use the following PROPERTY
syntax as well.
PROPERTY <EnhancedDBGridComponentID> SortAsc 'columnname'
PROPERTY <EnhancedDBGridComponentID> SortDesc 'columnname'
-- To Dynamically Sort (ASC) the first column (Company)
PROPERTY DBGrid_Customers SortAsc 'Company'
-- To Dynamically Sort (DESC) the first column (Company)
PROPERTY DBGrid_Customers SortDesc 'Company'
-- To Dynamically Sort (ASC) the second column (City)
PROPERTY DBGrid_Customers SortAsc 'City'
-- To Dynamically Sort (DESC) the second column (City)
PROPERTY DBGrid_Customers SortDesc 'City'
For more details and examples, refer to R:Docs 9.5 (Update 3).
Enjoy the showcase and pride of our eXpanded R:Dream Team!
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.
================================================
