Monday, August 7, 2017
Tip of the Day: LIST Computed, Autonumbered, and Default Value Columns
Product.......: R:BASE X and R:BASE X Enterprise (Version 10)
Build.........: 10.0.2.20731 or higher
Section.......: Commands
Keywords......: LIST, COMPUTED, AUTONUM, DEFAULT, Column Definition
Did you know the defined Computed, Autonumbered, and Default value columns can
be displayed for a connected database?
The LIST command has been enhanced with additional parameters to display a list
of Computed, Autonumbered, and Default value columns.
Syntax:
LIST COMPUTED
Displays the column name, table name, and attributes for each computed column
LIST AUTONUM
Displays the column name, table name, and attributes for each
autonumbered column
LIST DEFAULT
Displays the column name, table name, and attributes for each column
with a default
value definition
-- Examples:
CONNECT RRBYW19
R>LIST COMPUTED
Computed Columns
Name Table Attributes
------------------ ------------------
----------------------------------------
Freight InvoiceHeader Type: CURRENCY
Expression: (NetAmount* .01)
Tax InvoiceHeader Type: CURRENCY
Expression: (NetAmount* .081)
InvoiceTotal InvoiceHeader Type: CURRENCY
Expression: (NetAmount+Freight+Tax)
Bonus SalesBonus Type: CURRENCY
Expression: (NetAmount*BonusPct)
SalePrice InvoiceDetail Type: CURRENCY
Expression: (Price-
(Price*Discount/100))
ExtPrice InvoiceDetail Type: CURRENCY
Expression: (Units*SalePrice)
EmpFullName2 Employee Type: TEXT
Expression: (EmpFName&EmpLName)
R>LIST AUTONUM
Autonumber Columns
Name Table Attributes
------------------ ------------------
----------------------------------------
ContID Contact Type: INTEGER
Next Value: 1040.
Increment by: 1.
EmpTID Titles Type: INTEGER
Next Value: 9.
Increment by: 1.
EmpID Employee Type: INTEGER
Next Value: 116.
Increment by: 1.
CustID Customer Type: INTEGER
Next Value: 136.
Increment by: 1.
R>LIST DEFAULT
Columns with Defaults
Name Table Attributes
------------------ ------------------
----------------------------------------
WebAddress Employee Type: TEXT
Default Value: C:\
One of the most important aspects in business growth is your company
data, and no
one else has more invested in your success than R:BASE Technologies.
Invest forward
with R:BASE!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
