Search results

Create the page "Numeric Data Commands" on this wiki!

• SET BELL
  ...f an attempt is made to enter invalid data (e.g. alphabetic character in a numeric field), or enter more characters into a field than it can contain when SET [[Category:Commands]]
  910 B (143 words) - 16:48, 12 November 2009
• @...GET
  Data entry ...l Forms Designer can be used to create data entry forms containing @...GET commands. See CREATE SCREEN for full details.
  17 KB (2,799 words) - 10:05, 8 February 2011
• TREPORT
  ...PORT report definition language (RDL). Reports defined in RDL can extract data from one or more tables. The LPP clause is used to specify the number of lines per page. The numeric expression <expN> represents the number of lines. By default the number of
  13 KB (2,054 words) - 09:26, 23 August 2011
• TOTAL
  Total the numeric fields in the currently selected table creating a new table to contain the ...ields specified in the <field list> will be totaled in the new table. All numeric fields copied to the new table will be totaled.
  3 KB (425 words) - 10:00, 30 November 2009
• SUM
  Sum numeric expressions against records in the currently selected table ... specified, in which case the <scope> will default to REST. Up to fifteen numeric expressions can be summed. You can specify different target memory variabl
  2 KB (365 words) - 11:56, 7 March 2017
• SKIP
  ...<expN> can be positive or negative. If the SKIP command is issued with no numeric expression <expN> specified then the record pointer advances on to the next ...rror will occur. SKIP 0 is most effective from within forms using REPLACE commands in a validation procedure. The SKIP command is primarily used in conjunctio
  2 KB (348 words) - 10:02, 30 November 2009
• PUBLIC
  Declare public memory variable and optionally assign a data type and value ...when a value is assigned. An attempt to assign a value of an incompatible data type will fail and return error 306. The following <datatype> values can b
  2 KB (205 words) - 10:33, 30 August 2011
• PRIVATE
  ...memory variables private to a procedure or program and optionally assign a data type and value ...when a value is assigned. An attempt to assign a value of an incompatible data type will fail and return error 306. The following <datatype> values can b
  3 KB (383 words) - 10:00, 30 August 2011
• MODIFY STRUCTURE
  ...e a field name as well as the field width. APPEND triggers defined in the data dictionary will be called for each record as the table is reloaded after a ... old field contents to be discarded.( e.g. changing from a Date field to a Numeric field.)
  2 KB (339 words) - 15:38, 12 November 2009
• MENU FIELDS
  [NUMERIC] ...ields are converted to character data types suitable for indexing on mixed data types.
  4 KB (588 words) - 14:41, 12 November 2009
• LOCAL
  ...y variable or array local to the current procedure and optionally assign a data type and value ...when a value is assigned. An attempt to assign a value of an incompatible data type will fail and return error 306. The following <datatype> values can b
  2 KB (242 words) - 10:34, 30 August 2011
• INDEX
  ...on functions STR(), DTOS() and LTOS(). If the STR() function is used on a numeric field in the index expression, the index key storage sequence is unaffected ...e kept up to date. A table can have up to 20 open single index files. If data is modified when the index file is not opened, the index file will have to
  7 KB (1,109 words) - 10:06, 30 November 2009
• DEFINE TABLE
  ...tings. For example, a choice list defined for a field in the Applications Data Dictionary is still accessible from within a table field. Fields belonging The numeric expression <expN> states the number of rows, or records, to display in the
  7 KB (1,110 words) - 15:50, 10 November 2009
• CREATE SCREEN
  ...ed instead of the default forms with the following Recital/4GL screen form commands: ...the work surface. Each field inherits the attributes from the Application Data Dictionary.
  22 KB (3,735 words) - 15:38, 10 November 2009
• CREATE REPORT
  |Decimal places||Specify the number of decimal places for numeric columns. |Total||Specify whether the column, if numeric, should be totaled..
  7 KB (1,067 words) - 15:38, 10 November 2009
• CREATE FROM
  |FIELD_TYPE||Character||1||Data type of field |FIELD_LEN||Numeric||3||Width of field
  1 KB (175 words) - 15:33, 10 November 2009
• CREATE
  ...fied, '.dbf' will be used. Database table filenames should not begin with numeric characters. ...o define a field. Required information includes the field name, the field data type and the field width. Field descriptions are optional, but recommended
  16 KB (2,532 words) - 12:15, 10 May 2017
• COPY STRUCTURE EXTENDED
  |FIELD_TYPE||Character||1||Data type |FIELD_LEN||Numeric||3||Width of field
  2 KB (258 words) - 15:19, 10 November 2009
• CLEAR AUTOMEM
  ...s can be generated automatically using the STORE AUTOMEM and USE...AUTOMEM commands. !Data Type||Empty
  1 KB (141 words) - 14:44, 10 November 2009
• CLASS - Properties
  [AS CHARACTER | NUMERIC | LOGICAL | DATE | <class>] [, ...] ====AS CHARACTER | NUMERIC | LOGICAL | DATE====
  3 KB (409 words) - 14:58, 14 December 2009