The good doctor strikes again!
Albert
On 23/04/2013 8:21 AM, A. Razzak Memon wrote:
At 09:21 AM 4/11/2013, Richardson, Jeff wrote:
Is there a way to sort an Enhanced DB Grid by multiple columns?
I can manage to sort by a single column by both methods of clicking
on the column header and by using the Property command. But I need
to be able to sort the results by multiple columns at times.
Anybody know a way?
I am using 9.5 (32) with the latest update.
Jeff,
Here's how:
01. Start R:BASE eXtreme 9.5 (32/64), Build: 9.5.2.20430 or higher ...
http://www.rupdates.com
02. CONNect the database and run the form with Enhanced DB Grid control
Example 01:
http://www.razzak.com/sampleapplications/MultiColSort_EDBGrid_01.jpg
03. Use [Ctrl + D] to bring up the screen to select column(s) for sort.
Example 02:
http://www.razzak.com/sampleapplications/MultiColSort_EDBGrid_02.jpg
04. Select the column name and then click on [Add Column] button to add
to the list.
Repeat the same to add column(s) for additional sort
Tip:
You may also double-click on the column name to "select and add" to
the list of columns to sort.
Example 03:
http://www.razzak.com/sampleapplications/MultiColSort_EDBGrid_03.jpg
Use [Remove Column] button to remove selected column from the list
Use [Move Up] or [Move Down] button to re-arrange the list of columns
Tip:
You may also double-click on the column name to "un-select" the
column
from the list of columns to sort.
05. Once done selecting all columns to sort, click on [OK] button to
close
the screen.
06. Notice the Enhanced DB Grid with Sorted Columns as defined in Step
04.
Example 04:
http://www.razzak.com/sampleapplications/MultiColSort_EDBGrid_04.jpg
07. Use [Shift + Ctrl + D] to clear the sort, if you wish.
That's all there is to it!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--- 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.
================================================
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.3272 / Virus Database: 3162/6266 - Release Date: 04/22/13
