Search results

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

• 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
• CLASS - Parameters
  PARAMETERS <name> [AS CHARACTER | NUMERIC | LOGICAL | DATE | <class name>] [, ...] ====AS CHARACTER | NUMERIC | LOGICAL | DATE====
  3 KB (405 words) - 11:38, 13 January 2010
• CALCULATE
  ... The value <expN2> represents the periodic payment amounts. <expN3> is a numeric value that represents an initial investment. The initial value should be a The WHILE <condition> can be used in conjunction with the FIND or SEEK commands, and the REST <scope>, to restrict the number of records which are processe
  3 KB (524 words) - 14:39, 10 November 2009
• BROWSE
  All the dictionary attributes defined in the Application Data Dictionary (ADD) are active in BROWSE. From the ADD, field validation, edi |:<column width>||The <column width> allows you to specify the numeric display width of a field.
  7 KB (1,174 words) - 10:21, 30 September 2016
• BLANK
  ...ch field depends on its data type. The following table describes how each data type is filled with blanks. !Data Type||Description
  2 KB (291 words) - 11:53, 30 November 2009
• AVERAGE
  Calculate the average of specified numeric expressions The AVERAGE command calculates the arithmetic mean of all the specified numeric expressions. All records in the currently selected table are averaged unle
  2 KB (269 words) - 10:26, 13 January 2010
• APPEND BLANK
  ...hich use the APPEND BLANK command followed by the REPLACE command. If the numeric expression <expN> is specified, then <expN> blank records will be added. [[Category:Commands]]
  941 B (124 words) - 09:45, 30 November 2009
• @...SAY
  |B||Left-justifies numeric data within the display. |F||Displays negative data blinking.
  6 KB (852 words) - 11:14, 30 November 2009
• @...GET...SPINNER
  Create a FoxPro style numeric spinner ... style numeric spinners. Spinners allow you to 'spin' through a series of numeric values. The top left hand corner of the spinner is positioned at row <expN
  5 KB (812 words) - 11:20, 10 June 2014
• @...GET - Radio Buttons
  ...selected push button is returned to the <memvar>, which must be of numeric data type. Radio buttons are displayed on the screen starting at the row <expN1 ...fied by including a set of color pairs in the COLOR clause or specifying a numeric COLOR SCHEME <expN3>. If you do not specify the COLOR | COLOR SCHEME claus
  5 KB (757 words) - 11:12, 30 November 2009
• @...GET - Push Buttons
  ...selected push button is returned to the <memvar>, which must be of numeric data type. ...fied by including a set of color pairs in the COLOR clause or specifying a numeric COLOR SCHEME <expN3>. If you do not specify the COLOR | COLOR SCHEME claus
  4 KB (728 words) - 16:27, 5 July 2011