Tuesday, September 3, 2013
Tip of the Day: Searching in Database Explorer
Product.: R:BASE eXtreme 9.5 (32/64)
Build...: 9.5.3.20829 or higher www.rupdates.com
Keywords: Search, Hot Keys
Section.: Undocumented Features
After CONNECTing the database, the Database Explorer includes the following
sections and appropriate columns when configured as "View as Details":
. Tables (Name, Comment, Columns, Rows)
. Views (Name, Comment, Columns)
. Stored Procedures (Name, Comment, Size, Date/Time, Version)
. Forms (Name, Main Table, Comment, Size, Date/Time*, Version*)
. Reports (Name, Main Table, Comment, Size, Date/Time*, Version*)
. Labels (Name, Main Table, Comment, Size, Date/Time*, Version*)
. External Forms (Name, Comment, Size, Date/Time, Version)
. Applications (Name, Date/Time, Version)
. Command Files (Name, Extension, Date/Time, Size)
* = R:BASE eXtreme 9.5 (64) only.
Did you know that you can use the "Ctrl + N" hot key to search for any
key word in appropriate column while selecting the appropriate section
of Database Explorer?
In a typical development environment, for example -- one remembers the
form has to be something ".... MAP ...". Using the "Ctrl + N" hot key
to search text, all forms containing map in the name and comment will
be highlighted, one at a time, for easy selection.
http://www.razzak.com/tips/SearchInDatabaseExplorer_01.jpg
http://www.razzak.com/tips/SearchInDatabaseExplorer_02.jpg
This feature would be eXtremely helpful for those that have databases
with significant number of tables, views, stored procedures, forms,
reports, labels, external forms, applications, and command files.
Note: The Ctrl + N will not do a search in the active or selected row.
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.
================================================
