Search results

From Recital Documentation Wiki
Jump to: navigation, search

Create the page "Data Commands" on this wiki!

Page title matches

Page text matches

  • SET XMLFORMAT
    ...AS XML. The XMLFORMAT can be either RECITAL or ADO (Microsoft® ActiveX® Data Objects). Any XML files created in the ADO format can be loaded with the O [[Category:Commands]]
    1 KB (163 words) - 12:25, 24 December 2009
  • SET WINDOW OF RELATION
    The SET WINDOW OF RELATION command activates a window to view and modify data that is related to an active BROWSE or EDIT window. As the record pointer is moved through the BROWSE or EDIT window, data in <window> is refreshed to show only those records that are related to the
    3 KB (429 words) - 16:00, 25 November 2009
  • SET VAXTIME
    ...ng portion of a VAX date. VAX dates are most commonly used with the [[RMS Data Files|RMS Replaceable Database Driver]] (RMS Bridge). [[Category:Commands]]
    1,016 B (147 words) - 15:53, 25 November 2009
  • SET VALIDATE
    Signify that data entered in a field on a form has passed validation checks ...of the field on the form. The validation procedure will only be called if data is entered in the field on the form, or the [HELP] key is pressed. See [[@
    1 KB (166 words) - 15:53, 25 November 2009
  • SET UNIQUE
    ...e system displays an appropriate message. The form cannot be exited until data entry is abandoned by pressing the [ABANDON] key, or a unique key is entere The UNIQUE keyword can also be included in the INDEX or REINDEX commands to provide the same effect as SET UNIQUE ON. By default, UNIQUE is OFF.
    2 KB (274 words) - 15:51, 25 November 2009
  • SET TSLENGTH
    ...pecified in <expN>. Smaller keys may result in inaccurate searches if the data is truncated. [[Category:Commands]]
    1 KB (155 words) - 15:44, 25 November 2009
  • SET STRINGLEN
    [[Category:Commands]] [[Category:Expressions and Type Conversion Set Commands]]
    1 KB (164 words) - 15:33, 25 November 2009
  • SET STRINGBUF
    [[Category:Commands]] [[Category:String Data]]
    769 B (92 words) - 15:34, 25 November 2009
  • SET SOFTSEEK
    Sets soft seeking of data [[Category:Commands]]
    911 B (135 words) - 15:37, 25 November 2009
  • SET SKIP
    ...up to the master data file, reading the next record and setting up related data files. ...ips previously set with the SET SKIP <alias> command. The SET SKIP ON/OFF commands enable or disable the satisfying of the master detail relationship defined
    2 KB (301 words) - 09:57, 16 August 2010
  • SET SEPARATOR
    [[Category:Commands]] [[Category:Numeric Data]]
    1 KB (180 words) - 15:27, 25 November 2009
  • SET SECONDS
    [[Category:Commands]] [[Category:Date and Time Data]]
    1 KB (149 words) - 15:27, 25 November 2009
  • SET RUNWAIT
    Enable or disable the ’wait message’ after RUN / ! / !! Commands and RUN() function. dialog message [Backup data tables to tape?]
    1,012 B (138 words) - 15:29, 25 November 2009
  • SET ROLLBACK
    ...if an error occurs during the execution of a program or if an Applications Data Dictionary validation constraint is not satisfied. [[Category:Commands]]
    2 KB (221 words) - 15:30, 25 November 2009
  • SET RELATION
    ... the relationships are automatically canceled. The SET RELATION ON or OFF commands enable or disable the satisfying of relationships on a system wide basis. ... BLANK command operates. Relationships can also be specified with @...GET commands, please see the @...GET command for details. It should be noted that the <
    3 KB (480 words) - 09:41, 13 January 2010
  • SET PRERECORD
    ... when the FORM is first activated with the EDIT, CHANGE, INSERT and APPEND commands. Once the form is active, the [PAGE UP], [PAGE DOWN] and [FIND] keys will [[Category:Commands]]
    2 KB (282 words) - 15:42, 21 August 2018
  • SET POSTRECORD
    ...ted before the record is updated and unlocked. Conditional parsing of the data entered may be performed at this time and the resulting condition returned. [[Category:Commands]]
    3 KB (413 words) - 15:33, 21 December 2012
  • 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 PATH
    set path to /home/app/prgs, /home/app/data [[Category:Commands]]
    2 KB (254 words) - 11:18, 25 January 2010
  • SET OPTIMIZE
    ...ys be performed in connection with a FOR condition. The SET INDEX and USE commands can both open a list of single indexes to be associated with the active tab ...n interface, or development project. Depending on your orientation to the data, the Information Center may serve as an application interface, and an organ
    2 KB (280 words) - 16:26, 23 November 2009
  • SET NEAR
    Sets ’soft’ seeking of data [[Category:Commands]]
    911 B (136 words) - 16:28, 23 November 2009
  • SET MARK
    [[Category:Commands]] [[Category:Date and Time Data]]
    939 B (132 words) - 16:21, 23 November 2009
  • SET LOCKTYPE
    ... before the update is made. Without a lock being placed, the state of the data cannot be guaranteed. ... whether the record has been modified before issuing the REPLACE or GATHER commands.
    2 KB (229 words) - 16:10, 23 November 2009
  • SET KEY TO
    ...input mode is entered. If the [MENUBAR] key is pressed, then any @...MENU commands which have been defined in the screen format file are activated. You can t [[Category:Commands]]
    2 KB (322 words) - 16:12, 23 November 2009
  • SET HOURS
    [[Category:Commands]] [[Category:Terminal Environment Set Commands]]
    1 KB (169 words) - 15:54, 23 November 2009
  • SET HIDDENFIELD
    ...read or write privileges. Fields are defined as hidden in the Application Data Dictionary (ADD). The ADD may be accessed from the CREATE or MODIFY STRUCT [[Category:Commands]]
    1 KB (172 words) - 15:56, 23 November 2009
  • SET HELP
    If SET HELP is ON, then Data Dictionary Help or @...GET...HELP messages will be displayed in the message [[Category:Commands]]
    615 B (85 words) - 15:57, 23 November 2009
  • SET GATEWAY
    ...an be used, specifying only the data source name as configured in the ODBC Data Source Administrator. // short format for local ODBC data source
    2 KB (248 words) - 11:52, 22 June 2010
  • SET FORMAT
    ...hecked until the form is activated with one of the full screen forms based commands. ...st field only if SET READINSERT is ON and the last GET field is not a memo data type. Form level triggers are only executed once when the READ command is
    2 KB (397 words) - 15:49, 23 November 2009
  • SET FIXED
    [[Category:Commands]] [[Category:Numeric Data]]
    813 B (106 words) - 15:50, 23 November 2009
  • SET FILETYPE
    Regardless of the file type used, the Recital Applications Data Dictionary (ADD) may still be used. When an Xbase database file is opened, ...tra system resources, due to the binary conversions required to access the data. This can result in performance degradation, particularly on large databas
    2 KB (318 words) - 15:52, 23 November 2009
  • SET FIELDVAL
    ...TO can still be used, because the <expC> is automatically converted to the data type of the calling variable. parameters data
    960 B (139 words) - 15:51, 23 November 2009
  • SET EPOCH
    [[Category:Commands]] [[Category:Date and Time Data]]
    1 KB (150 words) - 15:45, 23 November 2009
  • SET ENCRYPTION
    ...e correct three-part encryption key must be specified before the table’s data or structure can be accessed. The SET ENCRYPTION TO set command can be use [[Category:Commands]]
    2 KB (273 words) - 15:46, 23 November 2009
  • SET DICTIONARY
    ... is OFF, and a table is opened that has an associated data dictionary, the data dictionary is ignored. To disable a dictionary file after the table has op [[Category:Commands]]
    2 KB (257 words) - 15:41, 23 November 2009
  • SET DESIGN
    ... not. The Recital Information Center is initiated with the INFO or DESIGN commands. ...ion, an application interface or a development project. Depending on your data requirements, the Information Center may serve as an application interface,
    2 KB (296 words) - 15:35, 23 November 2009
  • SET DECIMALS
    [[Category:Commands]] [[Category:Numeric Data]]
    1 KB (156 words) - 15:36, 23 November 2009
  • SET DATE
    [[Category:Commands]] [[Category:Date and Time Data]]
    1 KB (188 words) - 10:58, 12 November 2009
  • SET CURRENCY
    [[Category:Commands]] [[Category:Numeric Data]]
    867 B (110 words) - 15:31, 23 November 2009
  • SET CONFIRM
    If SET CONFIRM is ON, the [RETURN] key must be pressed to finish entering data into a field on a form. When CONFIRM is OFF, filling the field causes the [[Category:Commands]]
    893 B (140 words) - 16:58, 12 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 CENTURY
    [[Category:Commands]] [[Category:Date and Time Data]]
    995 B (128 words) - 16:46, 12 November 2009
  • SET CATALOG
    ...plays catalogs by listing filenames in panels of the following categories: Data, Text, Form, Report, Label, and Program. One file can exist in more than o [[Category:Commands]]
    2 KB (345 words) - 16:46, 12 November 2009
  • SET CARRY
    Enable or disable data carry over to the new record added to the table ... with the APPEND BLANK, APPEND BLANK <expN>, INSERT BLANK or INSERT BEFORE commands. Alternatively, when the APPEND or INSERT screens are active, pressing the
    1 KB (175 words) - 16:46, 12 November 2009
  • SET BELL
    ...N then the terminal bell will sound if an attempt is made to enter invalid data (e.g. alphabetic character in a numeric field), or enter more characters in [[Category:Commands]]
    910 B (143 words) - 16:48, 12 November 2009
  • SET AUTOJOIN
    ...index is generated on a field in the target table which has the same name, data type and width as that which is specified in the SET RELATION command. The [[Category:Commands]]
    2 KB (256 words) - 16:40, 12 November 2009
  • SET AUTOCATALOG
    ...ws updates to the catalog to be toggled on and off. Once the auto catalog commands are active, tables and their indexes can be opened from the interactive pro .... Database commands can be issued as SQL statement commands or as Recital commands.
    2 KB (305 words) - 07:12, 12 October 2010
  • @...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
  • SAVE DATASESSION
    Save the status of the current data session [[Category:Commands]]
    1 KB (196 words) - 11:21, 24 October 2016
  • Configuration Files
    ...Variables|Environment Variables]] and Recital [[:Category:Set_Commands|SET COMMANDS]]. ...products. For a sample and links to relevant [[:Category:Set Commands|set commands]], please see [[config.db]].
    4 KB (630 words) - 13:19, 8 March 2012
  • Error Messages: Recital
    |27||Data type mismatch |70||Illegal data format in FROM file
    16 KB (2,360 words) - 15:37, 14 December 2009
  • ZAP
    [[Category:Commands]] [[Category:Table Basics Commands]]
    1 KB (225 words) - 10:04, 30 November 2009
  • USE
    An empty memory variable of corresponding name, data type and size will be created for each field from the table. ...er index file, and is used to search for key values with the SEEK and FIND commands. The SET ORDER TO command can be used to reselect a master index from the
    5 KB (878 words) - 14:52, 7 January 2010
  • UPDATE
    Update the contents of the active table with data from another table The UPDATE command updates fields in the active table based upon data from another table. The <key expression> must exist in both tables. The a
    1 KB (228 words) - 16:27, 25 November 2009
  • TRY
    |Tag||Used to store any additional string data required. [[Category:Commands]]
    5 KB (663 words) - 16:26, 25 November 2009
  • TREPORT
    ...PORT report definition language (RDL). Reports defined in RDL can extract data from one or more tables. ...ommand. EXECUTE is normally used to perform report calculations. Typical commands used with EXECUTE are SKIP, SEEK, and STORE. You should not execute TREPOR
    13 KB (2,054 words) - 09:26, 23 August 2011
  • TOTAL
    ...WHILE <condition> can be used in conjunction with the FIND, SEEK or LOCATE commands, and the REST <scope> to restrict the range of records which are processed. [[Category:Commands]]
    3 KB (425 words) - 10:00, 30 November 2009
  • SUM
    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 [[Category:Commands]]
    2 KB (365 words) - 11:56, 7 March 2017
  • STORE AUTOMEM
    ...responding to the current record. A memory variable with a matching name, data type and length is created for each field in the current record. The memor [[Category:Commands]]
    959 B (128 words) - 16:19, 25 November 2009
  • SKIP
    ...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 [[Category:Commands]]
    2 KB (348 words) - 10:02, 30 November 2009
  • SEEK
    ...sion functions STR(), DTOS() and LTOS() are used to build indexes on mixed data types. The DESCEND() function can also be used to build indexes in descend [[Category:Commands]]
    2 KB (330 words) - 09:57, 30 November 2009
  • SCATTER
    ...pecified, the elements are created but are empty and are the same size and data types as the specified fields. ..., the memory variables are created but are empty and are the same size and data types as the specified fields.
    2 KB (285 words) - 13:56, 26 July 2010
  • SCAN
    [[Category:Commands]] [[Category:Table Basics Commands]]
    1 KB (137 words) - 07:43, 20 June 2010
  • SAVE RECORDVIEW
    ...ation from the specified memory variable. The SAVE and RESTORE RECORDVIEW commands are particularly useful in validation and hot key procedures when you want // Validate data
    2 KB (215 words) - 10:23, 13 June 2011
  • RESTORE RECORDVIEW
    The SAVE and RESTORE RECORDVIEW commands are useful in validation and hot key procedures when you want to move off t // Validate data
    1 KB (189 words) - 10:24, 13 June 2011
  • REPLACE AUTOMEM
    ...es can be generated automatically using the STORE AUTOMEM or USE…AUTOMEM commands. [[Category:Commands]]
    881 B (117 words) - 16:12, 12 November 2009
  • REPLACE
    ...in the current record to be set to blank. Default settings defined in the Data Dictionary apply to the replaced record. ... a previously declared two-dimensional <array> of the specified name. The data types and sizes of elements in the rows of the arrays must correspond to th
    4 KB (723 words) - 15:02, 8 January 2010
  • REINDEX 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 [[Category:Commands]]
    2 KB (294 words) - 17:29, 22 December 2009
  • REINDEX
    [[Category:Commands]] [[Category:Indexing Commands]]
    2 KB (218 words) - 10:05, 30 November 2009
  • RECALL
    ... .F.. The WHILE clause is often used in conjunction with the FIND or SEEK commands to RECALL records which have a common key. [[Category:Commands]]
    2 KB (314 words) - 16:13, 3 September 2010
  • READ MENU BAR
    menu 3,data,9,9 [[Category:Commands]]
    1 KB (214 words) - 16:08, 12 November 2009
  • READ
    Activate objects created with @...GET commands ...nd issuing another READ allows for the creation of nested READs. The READ commands can be nested to a depth of five levels.
    4 KB (709 words) - 11:19, 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
  • PACK 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 [[Category:Commands]]
    2 KB (312 words) - 17:29, 22 December 2009
  • PACK
    [[Category:Commands]] [[Category:Table Basics Commands]]
    1 KB (143 words) - 10:05, 30 November 2009
  • ON READERROR
    Execute specified command when a data entry error occurs ... command executes the specific <command> when a data entry error is made. Data entry errors are: invalid dates, number out of range, failed VALID conditio
    1 KB (143 words) - 15:55, 12 November 2009
  • 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 Changes of incompatible data types cause the old field contents to be discarded.( e.g. changing from a D
    2 KB (339 words) - 15:38, 12 November 2009
  • MODIFY GATEWAY
    [[Category:Commands]] [[Category:Terminal Development Tools Commands]]
    894 B (116 words) - 11:47, 22 June 2010
  • MODIFY BRIDGE
    ...ATE]], [[CREATE BRIDGE]], [[CREATE TABLE]], [[CREATE VIEW]], [[DO]], [[RMS Data Files]], [[SET VIEW]], [[SQL CREATE BRIDGE]], [[USE]] [[Category:Commands]]
    1 KB (146 words) - 11:45, 22 June 2010
  • MENU FIELDS
    ...ields are converted to character data types suitable for indexing on mixed data types. [[Category:Commands]]
    4 KB (588 words) - 14:41, 12 November 2009
  • MENU BROWSE
    ...ce lists which use MENU BROWSE can be defined globally in the Applications Data Dictionary (see CREATE), or by using the CHOICELIST clause with the @…GET [[Category:Commands]]
    5 KB (708 words) - 14:42, 12 November 2009
  • MENU BAR
    ...xpN>. This command is used in conjunction with the READ MENU BAR and MENU commands. top[3,1] = "DATA"
    2 KB (239 words) - 14:42, 12 November 2009
  • LOGOUT
    [[Category:Commands]] [[Category:Remote Data Connectivity]]
    492 B (55 words) - 11:51, 22 June 2010
  • LOGIN
    [[Category:Commands]] [[Category:Remote Data Connectivity]]
    1 KB (206 words) - 11:51, 22 June 2010
  • 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
  • LIST TABLES
    ...ectory. The environment variable DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other [[Category:Commands]]
    3 KB (358 words) - 10:05, 26 August 2011
  • LIST DATABASE
    ...The environment variable / symbol DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other * Database Path, e.g. /usr/recital/data/southwind
    3 KB (418 words) - 14:26, 26 October 2011
  • INSTALL
    ...nd imports Recital bridge files and tables and their associated structure, data, memo, dictionary and multiple index files from ASCII format to allow them [[Category:Commands]]
    1 KB (207 words) - 16:53, 11 November 2009
  • INSERT
    ...tion may also be automatically inserted into the form via the Applications Data Dictionary. [[Category:Commands]]
    4 KB (623 words) - 16:53, 11 November 2009
  • INFO
    ...cital Information Center is a powerful worksurface, from which any type of data may be accessed, viewed, modified and organized. Within the Recital Inform |Data||Table (.dbf), gateway (.gtw), bridge (.brg), view (.vue)
    3 KB (483 words) - 16:54, 11 November 2009
  • INDEX
    ...haracter, date or numeric expression. You can construct an index on mixed data types using the conversion functions STR(), DTOS() and LTOS(). If the STR( ...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
  • GOTO
    [[Category:Commands]] [[Category:Table Basics Commands]]
    2 KB (309 words) - 10:03, 30 November 2009
  • GENERATE
    ...rrently selected table. The fields in the new records will contain random data. [[Category:Commands]]
    543 B (68 words) - 16:51, 11 November 2009
  • GATHER
    ... then automatic record locking is performed for the update operation. The data types of the array elements or memory variables and corresponding fields mu [[Category:Commands]]
    2 KB (276 words) - 13:55, 26 July 2010
  • FUNCTION
    ...ecital UDFs can be used not only in programs, but also in the Applications Data Dictionary, the Report Writer and wherever a standard Recital function can ...t to the number of functions that can be declared in the Recital/4GL. The commands LIST PROCEDURE or DISPLAY PROCEDURE will let you see all currently active f
    3 KB (426 words) - 10:34, 30 August 2011
  • ENCRYPT
    The ENCRYPT command is used to encrypt the data in the specified table, <.dbf> or tables matching the <skeleton>. If the < [[Category:Commands]]
    1 KB (181 words) - 09:15, 24 May 2010
  • EDIT
    ...ressed. If the [ABANDON] key is pressed and changes have been made to the data, SET VERIFY ON causes a dialog box to be displayed asking for confirmation. [[Category:Commands]]
    7 KB (1,196 words) - 11:22, 30 November 2009
  • DISPLAY TABLES
    ...ectory. The environment variable DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other DISPLAY commands differ from LIST commands in that they pause every screen until a key is pressed. You can cancel any
    3 KB (403 words) - 17:27, 22 December 2009
  • DISPLAY DATABASE
    ...The environment variable / symbol DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other * Database Path, e.g. /usr/recital/data/southwind
    3 KB (471 words) - 16:00, 10 November 2009
  • DIALOG GET
    The SET COLOR and SET COLOR OF DIALOGFRAME commands may be used to specify the colors for the dialog box and frame. ...a type, its value will be retained. If it does exist, but is of any other data type, it will be changed to an empty character string with a length of 80 c
    2 KB (366 words) - 15:56, 10 November 2009
  • DESIGN
    ...cital Information Center is a powerful worksurface, from which any type of data may be accessed, viewed, modified and organized. Within the Recital Inform |Data||Table (.dbf), gateway (.gtw), bridge (.brg), view (.vue).
    3 KB (508 words) - 15:58, 10 November 2009
  • DELETE
    [[Category:Commands]] [[Category:Table Basics Commands]]
    2 KB (275 words) - 16:20, 3 September 2010
  • 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 ...S and the box will be the color of BOXES. The optional COLOR and BOXCOLOR commands specify alternate colors for the table and the box, respectively. A TITLE
    7 KB (1,110 words) - 15:50, 10 November 2009
  • DECRYPT
    The DECRYPT command is used to decrypt the data in the specified table, <.dbf> or tables matching the <skeleton>. The <exp The DECRYPT command decrypts the data and removes the table's .dkf file. After decryption, the key need no longe
    1 KB (166 words) - 09:16, 24 May 2010
  • CREATE VIEW
    ...s a single object. Views are very useful for performing ad-hoc queries on data that is in multiple related tables. [[Category:Commands]]
    3 KB (463 words) - 15:38, 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
    ...port is run. All fields selected are automatically converted to character data types. [[Category:Commands]]
    7 KB (1,067 words) - 15:38, 10 November 2009
  • CREATE GATEWAY
    ...to create a gateway file to an external SQL database table. See Supported Data Sources for the SQL Databases that can be accessed on each individual platf [[Category:Commands]]
    2 KB (252 words) - 11:47, 22 June 2010
  • CREATE FROM
    |FIELD_TYPE||Character||1||Data type of field [[Category:Commands]]
    1 KB (175 words) - 15:33, 10 November 2009
  • CREATE DICTIONARY
    Create a new applications data dictionary from an xad file [[Category:Commands]]
    711 B (90 words) - 15:33, 10 November 2009
  • CREATE BRIDGE
    Create a bridge definition for connection to C-ISAM data files ...ATE]], [[CREATE TABLE]], [[CREATE VIEW]], [[DO]], [[MODIFY BRIDGE]], [[RMS Data Files]], [[SET VIEW]], [[SQL CREATE BRIDGE]], [[USE]]
    4 KB (682 words) - 11:44, 22 June 2010
  • CREATE
    ...o define a field. Required information includes the field name, the field data type and the field width. Field descriptions are optional, but recommended ... data types. The spacebar can also be used to cycle through the supported data types.
    16 KB (2,532 words) - 12:15, 10 May 2017
  • COUNT
    The WHILE clause can be used in conjunction with the SEEK or LOCATE commands to restrict the range of records counted. When the WHILE option is used th [[Category:Commands]]
    1 KB (201 words) - 09:57, 30 November 2009
  • COPY
    ... copy to retrieve fields from multiple data files to be copied to a single data file. The number of records copied when using alias pointers is determined ...ge of records processed. When used in conjunction with the SEEK or LOCATE commands, it allows a quick way of copying selected records. The record pointer wil
    7 KB (1,183 words) - 15:31, 23 June 2010
  • COPY STRUCTURE EXTENDED
    |FIELD_TYPE||Character||1||Data type [[Category:Commands]]
    2 KB (258 words) - 15:19, 10 November 2009
  • COPY DICTIONARY
    The COPY DICTIONARY command is used to import attributes in an Application Data Dictionary (ADD) into a table file. A new dictionary may be created by usi ...table. These may be modified using any of the standard 4GL record editing commands (EDIT, REPLACE etc) if required.
    1 KB (208 words) - 15:22, 10 November 2009
  • CONVERT
    ...ous Recital versions. Therefore, before you can use your existing Recital data tables, they must be converted to the new file structure. The CONVERT comm [[Category:Commands]]
    2 KB (260 words) - 11:11, 5 October 2010
  • COMPILE 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 [[Category:Commands]]
    2 KB (251 words) - 17:33, 22 December 2009
  • CLOSE TABLES
    ...ectory. The environment variable DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other [[Category:Commands]]
    2 KB (243 words) - 17:25, 22 December 2009
  • CLOSE 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 ...DATABASE does not close gateway sessions. The SET GATEWAY TO or CLOSE ALL commands can be used for this purpose.
    2 KB (241 words) - 17:34, 22 December 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
    ... from a different data type: doing this will result in the run-time error "Data type mismatch". ... build a hierarchy of descendant objects. The specification of a property data type as an existing class name provides for construction of a class hierar
    3 KB (409 words) - 14:58, 14 December 2009
  • CLASS - Parameters
    ... from a different data type. Doing this will result in the run-time error "Data type mismatch". ... build a hierarchy of descendant objects. The specification of a property data type as an existing class name provides for construction of a class hierarc
    3 KB (405 words) - 11:38, 13 January 2010
  • CLASS - Methods
    ...of the methods that perform operations on the object. Encapsulation hides data within an object, and makes an object into a full self-contained operationa [[Category:Commands]]
    5 KB (712 words) - 11:34, 13 January 2010
  • CLASS
    ...object is a self-contained unit of data and functions that manipulate that data. A class is a specification of an object. A class contains memory variabl ...ecital command can be used in building methods in the class, however these commands cannot be used outside the method definition inside a CLASS...ENDCLASS cons
    3 KB (471 words) - 11:33, 13 January 2010
  • CHANGE
    ...ressed. If the [ABANDON] key is pressed and changes have been made to the data, SET VERIFY ON causes a dialog box to be displayed asking for confirmation. [[Category:Commands]]
    7 KB (1,183 words) - 14:39, 10 November 2009
  • CALCULATE
    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 [[Category:Commands]]
    3 KB (524 words) - 14:39, 10 November 2009
  • BUILD
    ...ted for each table that has a memo file and a '.xdd' file for each table's data. These files contain the information required to rebuild the files on the The matching '.str' file and the target data files are automatically picked up. For the cisamdemo.dbf bridge, this mean
    3 KB (445 words) - 14:36, 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 ...data input to a range of values. The expressions specified must match the data type of the field and represent low <expr1> and high <expr1> values. The s
    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
    ...ied <condition> is true. When used in conjunction with the SEEK or LOCATE commands, it gives a quick way of averaging selected records. When the WHILE clause [[Category:Commands]]
    2 KB (269 words) - 10:26, 13 January 2010
  • APPEND FROM ARRAY
    ...iously declared two-dimensional array of the specified name, <array>. The data types and sizes of elements in the rows of the arrays must correspond to th [[Category:Commands]]
    2 KB (229 words) - 13:51, 26 July 2010
  • APPEND FROM
    ...is encrypted, its DES3 encryption key must be entered correctly before the data can be accessed. The key can be specified using ENCRYPTION <expC2>, where [[Category:Commands]]
    5 KB (881 words) - 15:31, 23 June 2010
  • APPEND BLANK
    ...rmation can automatically be inserted into the record via the Applications Data Dictionary (ADD). Using this method can greatly increase performance of ba [[Category:Commands]]
    941 B (124 words) - 09:45, 30 November 2009
  • APPEND
    ...tion may also be automatically inserted into the form via the Applications Data Dictionary. ...conjunction with the FMT() function and the SAVE SCREEN and RESTORE SCREEN commands. If the topmost form is 'boxed' using the @...TO...LABEL command, the area
    5 KB (831 words) - 11:20, 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
    ...rrect and the button group is exited. If it evaluates to false (.F.), the data change is rejected. The optional ERROR clause causes the character express [[Category:Commands]]
    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 ...rrect and the button group is exited. If it evaluates to false (.F.), the data change is rejected. The VALID <expN7> option may be used with a function t
    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. [[Category:Commands]]
    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
  • @...EDIT
    Create a FoxPro style text-editing region for data input [[Category:Commands]]
    3 KB (515 words) - 10:57, 30 November 2009
  • SQL SELECT
    Retrieves data from one or more tables or views [INTO <data variable> [,...] | ARRAY <array-name> |
    19 KB (2,901 words) - 09:11, 7 January 2010
  • SQL UPDATE
    ...E statement updates columns in the specified &#060;table&#062;. To update data you must be the owner of the table or have already been granted UPDATE priv ...The environment variable / symbol DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other
    4 KB (583 words) - 14:08, 22 August 2014
  • DBC CLOSEDATA
    // Commands // Commands
    2 KB (306 words) - 16:50, 15 December 2009
  • DBC OPENDATA
    // Commands // Commands
    3 KB (348 words) - 16:50, 15 December 2009
  • SQL INSERT
    ...statement with a sub-query adds the rows returned by the query. To insert data you must be the owner of the table or have already been granted INSERT priv ...ectory. The environment variable DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other
    4 KB (694 words) - 09:13, 7 January 2010
  • CREATE TABLE
    ...nts|CONSTRAINTS]], [[CREATE DATABASE]], [[CREATE INDEX]], [[SQL Data Types|DATA TYPES]], [[DROP DATABASE]], [[DROP TABLE]], [[GETENV()]], [[SQL INSERT|INSE ...rrent database. The INSERT command can be used to populate the table with data. The ALTER TABLE command is used to change the table definition once it is
    5 KB (696 words) - 10:37, 28 November 2012
  • ALTER TABLE
    ..., [[CREATE INDEX]], [[CREATE TABLE]], [[CREATE TRIGGER]], [[SQL Data Types|DATA TYPES]], [[DELETE TRIGGER]], [[DROP DATABASE]], [[DROP INDEX]], [[DROP TABL ...ame columns. The ALTER TABLE statement automatically reloads the original data of the table back into the original columns. You must have ALTER privilege
    5 KB (798 words) - 16:34, 30 July 2013
  • DROP TABLE
    Removes a table and all its data from the database The DROP TABLE command removes a table and all its data from the database. When you drop the table, it removes the specified table
    2 KB (309 words) - 08:00, 12 October 2010
  • CREATE 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 [[Category:Commands]]
    2 KB (324 words) - 10:20, 26 August 2011
  • DROP 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 [[Category:Commands]]
    2 KB (234 words) - 17:29, 22 December 2009
  • 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 |CATEGORY||Data - Recital, FoxPro, dBase and Clipper tables and Recital Bridge Files with '
    8 KB (1,239 words) - 10:19, 26 August 2011
  • CREATE CONNECTION
    ...es]], [[DROP CONNECTION]], [[SQL Remote Data Connectivity Functions|REMOTE DATA CONNECTIVITY FUNCTIONS]], [[SET SQL]] ...nection file can be used by the SQLCONNECT() and SQLSTRINGCONNECT() remote data connectivity functions to establish a connection for SQL access to the data
    4 KB (626 words) - 15:30, 10 November 2009
  • RESTORE 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 [[Category:Commands]]
    3 KB (415 words) - 17:30, 22 December 2009
  • BACKUP 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 [[Category:Commands]]
    3 KB (463 words) - 09:21, 11 October 2010
  • REBUILD 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 [[Category:Commands]]
    2 KB (299 words) - 11:37, 16 December 2009
  • ADD TABLE
    ...The environment variable / symbol DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other [[Category:Commands]]
    2 KB (249 words) - 10:19, 26 August 2011
  • SQL USE
    ...The environment variable / symbol DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other [[Category:Commands]]
    2 KB (281 words) - 16:20, 25 November 2009
  • DROP CONNECTION
    [[CREATE CONNECTION]], [[SQL Remote Data Connectivity Functions|REMOTE DATA CONNECTIVITY FUNCTIONS]] ... command and can be used by the SQLCONNECT() and SQLSTRINGCONNECT() remote data connectivity functions to establish a connection for SQL access to a databa
    1 KB (165 words) - 17:04, 10 November 2009
  • DROP PROCEDURE
    ...unctionality. The SET DATADIR command can also be used to set the default data search directory. [[Category:Commands]]
    2 KB (284 words) - 15:50, 22 December 2009
  • FETCH
    INTO [<data variable> [, ...] | XML <xml filename>] ...ues in the specified row from the open cursor and places them in the bound data variables. If the variables do not exist, they are created. If they do ex
    3 KB (396 words) - 14:43, 22 December 2009
  • GRANT
    |ALTER||The data type to be stored in that column, and the applicable length or precision. ...ectory. The environment variable DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other
    3 KB (460 words) - 17:42, 22 December 2009
  • LOCK TABLE
    ...The environment variable / symbol DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other [[Category:Commands]]
    2 KB (287 words) - 17:28, 22 December 2009
  • OPEN
    ...d in an application program. A logical table is a temporary collection of data that satisfies conditions specified in a SELECT statement. Once a declared [[Category:Commands]]
    1 KB (204 words) - 14:37, 22 December 2009
  • REVOKE
    |ALTER||The data type to be stored in that column, and the applicable length or precision. ...The environment variable / symbol DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other
    3 KB (440 words) - 17:43, 22 December 2009
  • DROP BRIDGE
    ...BRIDGE]], [[CREATE TABLE]], [[CREATE VIEW]], [[DO]], [[DROP TABLE]], [[RMS Data Files]], [[SET VIEW]] [[Category:Commands]]
    776 B (107 words) - 17:41, 22 December 2009
  • DELETE TRIGGER
    ...s|CONSTRAINTS]], [[CREATE DATABASE]], [[CREATE TRIGGER]], [[SQL Data Types|DATA TYPES]], [[DB_DATADIR]], [[DROP TABLE]], [[GETENV()]], [[SQL INSERT|INSERT] ...The environment variable / symbol DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other
    2 KB (258 words) - 15:46, 10 November 2009
  • SQL DELETE
    ...ectory. The environment variable DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other [[Category:Commands]]
    2 KB (309 words) - 15:25, 15 March 2012
  • DECLARE CURSOR
    ...d in an application program. A logical table is a temporary collection of data that satisfy conditions specified in a SELECT statement. Declared cursors [[Category:Commands]]
    2 KB (251 words) - 14:35, 22 December 2009
  • SQL CREATE VIEW
    ...at allows you to access data from other tables. A view itself contains no data. ...bc.ini file is manually modified. The data extracted from the view is the data current at the time of the SELECT statement, not at the time of the view cr
    2 KB (272 words) - 12:44, 6 January 2010
  • CREATE TRIGGER
    ...NDEX]], [[ALTER TABLE]], [[SQL Constraints|CONSTRAINTS]], [[SQL Data Types|DATA TYPES]], [[DB_DATADIR]], [[DELETE TRIGGER]], [[DROP TABLE]], [[GETENV()]], ...The environment variable / symbol DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other
    2 KB (312 words) - 15:38, 10 November 2009
  • CREATE PROCEDURE
    ...unctionality. The SET DATADIR command can also be used to set the default data search directory. [[Category:Commands]]
    3 KB (354 words) - 11:05, 23 December 2009
  • SET DATADIR
    set datadir to /usr/app1/data</code> [[Category:Commands]]
    1 KB (152 words) - 15:31, 23 November 2009
  • CREATE CURSOR
    |datatype ||The column's data type. [[Category:Commands]]
    3 KB (367 words) - 11:00, 16 December 2009
  • SQL CREATE BRIDGE
    Creates a Recital bridge file for connection to RMS or C-ISAM data files ... RMS File types: RMS Indexed Sequential, RMS Relative and RMS Sequential. Data access is achieved through a bridge. This requires the creation of a bridg
    4 KB (522 words) - 17:39, 22 December 2009
  • SQL CLOSE
    ... pointer to a logical table. A logical table is a temporary collection of data that satisfy conditions specified in a SELECT statement. After a cursor ha [[Category:Commands]]
    955 B (139 words) - 17:24, 22 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 [[Category:Date and Time Data]]
    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. [[Category:Date and Time Data]]
    2 KB (205 words) - 16:38, 27 November 2009
  • CENTER()
    ...ich is <expN> characters wide. Note that if the MESSAGE or SET MESSAGE TO commands are used, the message text is automatically centered. [[Category:String Data]]
    816 B (95 words) - 16:05, 27 November 2009
  • ASTORE()
    ...ray. The ASTORE() function is most commonly used in combination with menu commands where multiple selections can be made. [[Category:String Data]]
    2 KB (238 words) - 13:53, 26 July 2010
  • Constants and Expressions
    ...curly braces {}. The format is determined by the SET DATE and SET CENTURY commands. ...ers, prefixed by 0x, can be used in place of decimal numbers except in the data entry/modification of numerics. (Linux platforms only).
    2 KB (257 words) - 11:25, 3 September 2010
  • Encryption
    ...t encryption key is specified, providing additional security for sensitive data. For more information on using DES3 Encryption, please see the following commands:
    716 B (92 words) - 09:17, 24 May 2010
  • XML
    ...nds support the export of Recital data to XML format and the import of XML data into Recital format. Recital also includes a series of functions for acces The format for XML files can be either RECITAL or ADO (Microsoft® ActiveX® Data Objects). Any XML files created in the ADO format can be loaded with the O
    3 KB (469 words) - 09:21, 7 January 2010
  • Memory Variables
    ...n the type of data that is, or can be, stored in it. In fact, the type of data stored in a particular variable can be changed at any time, although this n ...ARE]] / [[DIMENSION]] commands or the [[PUBLIC]] / [[PRIVATE]] / [[LOCAL]] commands. The size of the array can be specified in parentheses or square brackets.
    4 KB (628 words) - 09:45, 22 October 2009
  • 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 |97=[Data\Talk]||Function key label [Data\Talk]
    25 KB (3,823 words) - 11:41, 4 March 2010
  • DATE STOD()
    ...igned long, the Recital date format. This function can be used to convert data values for updating Recital date memory variables. /* commands */
    1 KB (177 words) - 10:59, 30 March 2009
  • SDK Function Levels
    ...ype and number of parameters passed and to convert Recital data types to C data types. A 'C' UDF which uses the RECITAL/API can have a variable number of ...view of Level 2|level 2]] are high-level functions used to execute RECITAL commands and evaluate expressions.
    2 KB (224 words) - 14:13, 30 March 2009
  • Recital.conf
    &#035; Used to determine whether calls to operating system commands should be<br> &#035; Used to define a default data directory for Recital databases.<br>
    16 KB (2,003 words) - 12:09, 9 March 2010
  • LIST PROFILE
    ...LIST PROFILE command works in conjunction with the PROFILE and SET PROFILE commands to list input/output, locking and procedure call statistics for a particula ====Profiler data====
    3 KB (394 words) - 14:42, 13 January 2010
  • DISPLAY PROFILE
    ...PLAY PROFILE command works in conjunction with the PROFILE and SET PROFILE commands to list input/output, locking and procedure call statistics for a particula ====Profiler data====
    3 KB (420 words) - 14:44, 13 January 2010
  • DISPLAY SCHEMAS
    ...rectory. The environment variable DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other DISPLAY commands differ from LIST commands in that they pause every screen until a key is pressed. You can cancel any
    3 KB (396 words) - 16:56, 15 December 2009
  • LIST SCHEMAS
    ...rectory. The environment variable DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other [[Category:Commands]]
    3 KB (357 words) - 16:56, 15 December 2009
  • Display and List
    |[[DISPLAY HISTORY]] / [[LIST HISTORY]]||Previously entered commands. |[[DISPLAY STATUS]] / [[LIST STATUS]]||Current status information, including data, settings and keys.
    3 KB (346 words) - 16:05, 10 February 2012
  • Recital Web Getting Started
    Recital Web is a data centric HTTP Server that incorporates a database engine and 4GL. Using Reci ... HTML files with Recital/4GL scripting embedded within them. Any scripting commands that are embedded within the file are executed then removed from the result
    12 KB (1,873 words) - 12:32, 7 February 2012
  • Recitaldump
    ...e run as root. For systems with a hidden root account, please precede the commands with '''sudo'''. ... backup is restored on a target system. You should add the Recital script commands used to rebuild the index files (.ndx) into this file. Multiple tag index
    2 KB (367 words) - 17:20, 15 March 2010
  • Recitalreplication
    ...st be run as root. For systems with a hidden root account, please precede commands with '''sudo'''. ...ver the publisher is running on. The password can also be specified in the data source.
    2 KB (324 words) - 18:30, 24 June 2010
  • COPY 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 [[Category:Commands]]
    2 KB (283 words) - 17:32, 22 December 2009
  • 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
  • Securing Your Data
    ==Securing Your Data== ===Controlling Access to Data===
    16 KB (2,447 words) - 12:12, 26 January 2010
  • Backup and Restore Databases
    ===Using the recitaldump Command to Backup Your Data=== ...e run as root. For systems with a hidden root account, please precede the commands with '''sudo'''.
    4 KB (631 words) - 10:19, 16 March 2010
  • 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
  • Understanding Recital Databases
    ...permitting - in whichever directory on the system they reside and database commands can target the files as a single unit. Databases are searched for in the s
    2 KB (354 words) - 15:04, 21 December 2009
  • 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
    You can view the contents of a static array using the [[ECHO|echo]] or [[?]] commands. ...view the contents of an associative 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: When dealing with string data types, the + and - operators perform the following concatenation operations
    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. ...type()]] or [[VARTYPE()|vartype()]] functions can be used to determine the data type of any variable.
    10 KB (1,445 words) - 14:08, 4 November 2014
  • Importing and Exporting Data
    ==Importing and Exporting Data== ...and [[COPY|copy to]] can respectively be used to import and export Recital data.
    6 KB (818 words) - 12:52, 6 July 2011
  • 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
  • LIST TIMELINE
    ...YYYYMMDD (date only). The [[DTOS()]] function can be used to convert date data type values to YYYYMMDD format. HH:MM:SS is the standard time format retur [[Category:Commands]]
    2 KB (284 words) - 09:44, 6 July 2011
  • ROLLBACK TIMELINE
    ...YYYYMMDD (date only). The [[DTOS()]] function can be used to convert date data type values to YYYYMMDD format. HH:MM:SS is the standard time format retur [[Category:Commands]]
    2 KB (237 words) - 12:02, 30 September 2016
  • DISPLAY TIMELINE
    ...YYYYMMDD (date only). The [[DTOS()]] function can be used to convert date data type values to YYYYMMDD format. HH:MM:SS is the standard time format retur [[Category:Commands]]
    2 KB (303 words) - 09:44, 6 July 2011
  • SET SMARTQUERY
    When SET SMARTQUERY ON is in effect, then data selected with SQL SELECT commands is cached. When the same SELECT query is run again and no modifications ha [[Category:Commands]]
    1 KB (152 words) - 16:04, 13 January 2010
  • SET AUTOHEAL
    ...lity applications as there is no need to have users log off to reindex the data. [[Category:Commands]]
    856 B (113 words) - 09:57, 3 July 2015
  • Recital Getting Started
    ...nd SQL commands can be typed into the ''command window'' and the following commands operate in a window rather than full screen: Individual windows can be deactivated, hidden or shown with the following commands:
    4 KB (597 words) - 10:54, 7 September 2010
  • 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
  • Recital Web Tutorial
    ...ient. Convert any data types ([[CTOD()]]) before loading the '''post[]''' data into the table. ? "Data updated"
    2 KB (331 words) - 13:02, 22 June 2011
  • SET STRESCAPE
    [[Category:Commands]] [[Category:String Data]]
    1 KB (128 words) - 11:44, 21 July 2010
  • RESTORE DATASESSION
    Save the status of the current data session [[Category:Commands]]
    1 KB (196 words) - 07:43, 3 June 2011
  • REMOVE TABLE
    ...The environment variable / symbol DB_DATADIR points to the current Recital data directory and can be queried using the GETENV() function. Files from other [[Category:Commands]]
    2 KB (242 words) - 10:18, 26 August 2011
  • SET STRCONVERT
    ...T is OFF, expressions must be converted manually using the ETOS() or other data conversion functions. [[Category:Commands]]
    947 B (118 words) - 09:17, 3 April 2012

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

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