Search results

From Recital Documentation Wiki
Jump to: navigation, search

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

  • SET STRINGLEN
    ...nction is not specified, STR() will return a string the same length as the numeric column. This command allows the optional logical expression <expL> to be e [[Category:Commands]]
    1 KB (164 words) - 15:33, 25 November 2009
  • SET SEPARATOR
    [[Category:Commands]] [[Category:Numeric Data]]
    1 KB (180 words) - 15:27, 25 November 2009
  • SET POINT
    [[Category:Commands]] [[Category:Numeric Data]]
    1 KB (185 words) - 16:57, 23 November 2009
  • SET PCPICTURE
    ...extra decimal places are truncated. If PCPICTURE is OFF, then the numeric data is properly rounded. This command has been added to aid in the porting of [[Category:Commands]]
    1 KB (180 words) - 16:59, 23 November 2009
  • SET FIXED
    Determines whether a fixed number of decimal places are displayed for numeric output If SET FIXED is ON, then all numeric output will be displayed with the number of decimal places specified by the
    813 B (106 words) - 15:50, 23 November 2009
  • SET DECIMALS
    ...ify the number of decimal places to be used when displaying the results of numeric expressions ... numeric functions and calculations. For calculations that do not involve numeric functions, division, or multiplication, the number of decimal places displa
    1 KB (156 words) - 15:36, 23 November 2009
  • SET CURRENCY
    [[Category:Commands]] [[Category:Numeric Data]]
    867 B (110 words) - 15:31, 23 November 2009
  • SET COMPATIBLE
    ...to enhance compatibility with other Xbase products. Certain functions and commands behave differently depending on which keyword is used with the SET COMPATIB When SET COMPATIBLE is set to any mode except RECITAL, the following SET commands are turned on. SET PROMPT is also set to ’.’.
    10 KB (1,436 words) - 11:16, 4 January 2012
  • SET CLIPPER5
    The SET CLIPPER commands toggles between use of Clipper 5 behavior and Recital behavior. This SET c |FIELD_TYPE||Character||1||data type of field
    3 KB (379 words) - 16:52, 12 November 2009
  • SET CLIPPER
    The SET CLIPPER commands toggles between use of Clipper behavior and Recital behavior. There are ce |FIELD_TYPE||Character||1||data type of field
    3 KB (377 words) - 16:52, 12 November 2009
  • 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
  • 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
  • @...GET - Check Boxes
    Create a FoxPro style check box for data input ...check box is returned to the <memvar>, which must be of logical or numeric data type.
    5 KB (738 words) - 16:21, 5 July 2011
  • OPEN DATABASE
    ...ectory. The environment variable DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other |CODE||Numeric||3||File group||N
    8 KB (1,239 words) - 10:19, 26 August 2011
  • CREATE CURSOR
    |datatype ||The column's data type. |NEXTVALUE <NextValue>||The specified <NextValue> is the numeric start value for the auto incrementing.
    3 KB (367 words) - 11:00, 16 December 2009
  • DATETIME()
    ...times is affected by the SET CENTURY, SET DATE, SET EPOCH and SET MARK set commands. The SET SECONDS set command determines whether seconds are displayed in t The optional parameters can be used to specify numeric years, months, days, hours, minutes and seconds and return a valid correspo
    2 KB (296 words) - 16:38, 27 November 2009
  • DATE()
    ...dates is affected by the SET CENTURY, SET DATE, SET EPOCH and SET MARK set commands. The optional <expN1>,<expN2>,<expN3> can be used to specify numeric years, months and days and return a valid corresponding date. If any param
    2 KB (205 words) - 16:38, 27 November 2009
  • Constants and Expressions
    |Numeric||An integer number of up to 16 digits (0-9) or a floating point number of u ...curly braces {}. The format is determined by the SET DATE and SET CENTURY commands.
    2 KB (257 words) - 11:25, 3 September 2010
  • Terminal Definition Files
    Entries 4,5 and 6 are used by the local printing commands [[SET DEVICE|SET DEVICE TO PRINT]], [[SET CONSOLE|SET CONSOLE OFF]] and [[S ...In the example above, the setting is \E= for application mode, and \E> for numeric mode.
    25 KB (3,823 words) - 11:41, 4 March 2010
  • Main Page
    # [[Working With String Data in Recital]] # [[Working With Date and Time Data in Recital]]
    2 KB (256 words) - 14:46, 16 November 2014
  • Using Navigational Data Access Commands in Recital
    ==Using Navigational Data Access Commands in Recital== ===Why use Navigational Data Access Commands===
    20 KB (2,992 words) - 10:51, 13 January 2010
  • Working With Numeric Data in Recital
    ==Working With Numeric Data in Recital== ...:Category:Set Commands|set commands]] change the display format of numeric data:
    6 KB (891 words) - 15:22, 22 January 2010
  • Working With Date and Time Data in Recital
    ==Working With Date and Time Data in Recital== Certain [[:Category:Set Commands|set commands]] change the date format:
    6 KB (864 words) - 17:39, 14 January 2010
  • Recital Arrays
    // change each array element to hold a numeric value You can view the contents of a static array using the [[ECHO|echo]] or [[?]] commands.
    11 KB (1,555 words) - 15:31, 9 January 2012
  • Recital Operators
    When dealing with Date data types, the operators work as follows: The ++ operator is used to automatically increment a previously declared numeric memory variable by one. The ++ operator must be placed at the beginning of
    6 KB (876 words) - 00:24, 3 December 2009
  • Recital Variables and Constants
    ...red as a particular data type, and in this case only values of the correct data type can be assigned. private nVar as numeric
    10 KB (1,445 words) - 14:08, 4 November 2014
  • A Recital Primer
    ...ou do not need to concern yourself about names that may already be used as commands. ...olumn of a line. A newline ends the command. If you have particularly long commands, you can them extend over multiple lines by placing the line continuation c
    24 KB (3,621 words) - 14:58, 22 May 2014
  • Recital Replication Configuration
    ...s stored in the ''replication'' database. The replication queue table meta data is defined below. | DATA
    19 KB (3,134 words) - 13:11, 4 October 2010

View (previous 500 | next 500) (20 | 50 | 100 | 250 | 500)

Retrieved from "https://www.recitalsoftware.com/wiki/index.php/Special:Search"