At 11:35 AM 6/28/2013, Dennis McGrath wrote:
It's a sweet thing now, and blazing fast which makes it extremely useful.
Thank you!
Enjoy the showcase and pride of our eXpanded R:Dream Team!
We are all very proud of making R:BASE what it is today.
The best is yet to come!
Very Best R:egards,
Razzak.
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of A.
Razzak Memon
Sent: Friday, June 28, 2013 10:15 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Tip of the Day: Displaying R:BASE Keys/Indexes
Friday, June 28, 2013
Tip of the Day: Displaying R:BASE Keys/Indexes
Product: R:BASE eXtreme 9.5 (32/64)
Build..: 9.5.3.20611 or higher www.rupdates.com
Section: Data Dictionary (F3) Key
Using R:BASE eXtreme 9.5 (32/64), while in Data Designer (RBDefine),
the [Key/Indexes] option allows users to create table constraints;
such as Primary Keys, Foreign Keys and Unique Keys. Users can also
create Indexes, which provide faster data retrieval for the database.
Did you know that you can retrieve and display a complete list of
Keys and Indexes, if defined, using the Data Dictionary (F3) key?
Among many other database and non-database information, the enhanced
Data Dictionary (F3) key in R:BASE eXtreme 9.5 (32/64), also includes
a tab for [Keys/Indexes]. Selecting [Keys/Indexes] tab will list all
database Keys and Indexes, if defined.
By default, all Keys and Indexes are displayed including details
such as, ID, Type, Table Name, and References. Clicking on the
appropriate column header will sort the column in ascending and
descending order accordingly.
However, if you wish to only display Primary Keys, Unique Keys,
Indexes, or Foreign Keys, you may use the Type: Drop-Down Filter
option located above the columns to specifically display your
selected option of Primary Keys, Unique Keys, Indexes, or Foreign
Keys, if you wish.
All: http://www.razzak.com/tips/RBG95_DataDictionary_All.jpg
PKs: http://www.razzak.com/tips/RBG95_DataDictionary_PKs.jpg
UKs: http://www.razzak.com/tips/RBG95_DataDictionary_UKs.jpg
Ind: http://www.razzak.com/tips/RBG95_DataDictionary_Indexes.jpg
FKs: http://www.razzak.com/tips/RBG95_DataDictionary_FKs.jpg
R:BASE eXtreme 9.5 (32/64) Data Dictionary [F3] key includes the
following options:
. Databases
. Tables
. Columns
. Keys/Indexes
. Variables
. Views
. Forms
. Reports
. Labels
. Functions
. Stored Procedures
. System Tables
. System Columns
. Themes
. Printers
. External Forms.
. Applications
. Colors
. Control Types
. Database Settings
. Files
While in Form Designer, the Data Dictionary includes the following
additional tabs:
. Form Component IDs
. Form Actions
While in Report Designer, the Data Dictionary includes the following
additional tab:
. Report Component IDs
While in Label Designer, the Data Dictionary includes the following
additional tab:
. Label Component IDs
While in External Form Designer, the Data Dictionary includes the
following additional tabs:
. External Form Component IDs
. External Form Actions
Enjoy the showcase and pride of our eXpanded R:Dream Team and 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!
--
