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

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

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