Search results

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