Search results

Create the page "Data Commands" on this wiki!

• @...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