Yet another wonderful idea from RBTI. This makes life a lot easier for developers. Thanks Razzak and Team.
Albert > On Aug 7, 2017, at 5:44 AM, A. Razzak Memon <[email protected]> wrote: > > 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. -- 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.
