Difference between revisions of "SET CLIPPER"

From Recital Documentation Wiki
Jump to: navigation, search
(Description)
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET CLIPPER=
 
 
 
==Class==
 
Xbase Compatibility
 
 
 
 
==Purpose==
 
==Purpose==
 
Support added Clipper compatibility
 
Support added Clipper compatibility
Line 16: Line 9:
 
==See Also==
 
==See Also==
  
CREATE, GOTO, PARAMETERS, PRIVATE, PUBLIC, SKIP, ASTORE(), EDITFIELD(), EOF(), FILE(), FILETYPE(), FOUND(), INDEXEXT(), MEMOEDIT(), SECONDS(), SECS(), VERSION(), SET CLIPPER5, SET COMPATIBLE, SET EDITFIELD, SET FILECASE, SET FILETYPE, SET INDEXEXT, SET MEMOEXT, SET PCEDIT, SET PCEXACT, SET PCFILTER, SET PCGRAPHICS, SET PCKEYS, SET PCLOCKING, SET PCPICTURE, SET PCSAYS, SET PCUNIQUE, DB_FOXPLUSBUGS, DB_FOXPROKEYS, DB_SAMBA
+
[[ASTORE()]], [[CREATE]], [[DB_FOXPLUSBUGS]], [[DB_FOXPROKEYS]], [[EDITFIELD()]], [[EOF()]], [[FILE()]], [[FILETYPE()]], [[FOUND()]], [[GOTO]], [[INDEXEXT()]], [[MEMOEDIT()]], [[PARAMETERS]], [[PRIVATE]], [[PUBLIC]], [[SECONDS()]], [[SECS()]], [[SET CLIPPER5]], [[SET COMPATIBLE]], [[SET EDITFIELD]], [[SET FILECASE]], [[SET FILETYPE]], [[SET INDEXEXT]], [[SET MEMOEXT]], [[SET PCEDIT]], [[SET PCEXACT]], [[SET PCFILTER]], [[SET PCGRAPHICS]], [[SET PCKEYS]], [[SET PCLOCKING]], [[SET PCPICTURE]], [[SET PCSAYS]], [[SET PCUNIQUE]], [[SKIP]], [[VERSION()]]
  
  
Line 36: Line 29:
  
  
{|
+
{| class="wikitable"
|Field||Type||Length||Description
+
!Field||Type||Length||Description
 
|-
 
|-
 
|FIELD_NAME||Character||32||field name
 
|FIELD_NAME||Character||32||field name
Line 50: Line 43:
 
|-
 
|-
 
|}
 
|}
 +
  
 
* Memory variables created with a PUBLIC or a PRIVATE statement are created with a type of UNDEFINED.
 
* Memory variables created with a PUBLIC or a PRIVATE statement are created with a type of UNDEFINED.
Line 58: Line 52:
  
 
* The VERSION() function will have a return value of ’Clipper Summer 87’.
 
* The VERSION() function will have a return value of ’Clipper Summer 87’.
 +
  
 
==Example==
 
==Example==
<pre>set clipper on
+
<code lang="recital">set clipper on
 
create strutable
 
create strutable
set clipper off</pre>
+
set clipper off</code>
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
[[Category:Set_Commands]]
+
[[Category:Set_Commands|CLIPPER]]

Latest revision as of 16:52, 12 November 2009

Purpose

Support added Clipper compatibility


Syntax

SET CLIPPER ON | OFF | (<expL>)


See Also

ASTORE(), CREATE, DB_FOXPLUSBUGS, DB_FOXPROKEYS, EDITFIELD(), EOF(), FILE(), FILETYPE(), FOUND(), GOTO, INDEXEXT(), MEMOEDIT(), PARAMETERS, PRIVATE, PUBLIC, SECONDS(), SECS(), SET CLIPPER5, SET COMPATIBLE, SET EDITFIELD, SET FILECASE, SET FILETYPE, SET INDEXEXT, SET MEMOEXT, SET PCEDIT, SET PCEXACT, SET PCFILTER, SET PCGRAPHICS, SET PCKEYS, SET PCLOCKING, SET PCPICTURE, SET PCSAYS, SET PCUNIQUE, SKIP, VERSION()


Description

The SET CLIPPER commands toggles between use of Clipper behavior and Recital behavior. There are certain instances where Clipper programs will behave slightly differently under the Recital environment. This SET command has been implemented to compensate for these differences. When SET CLIPPER is ON the following will be in effect:

  • The ASTORE() function will not trim the strings that are stored in the array passed to ASTORE().
  • The FILE() function will not concatenate ’.dbf’ to the parameter, if the parameter passed does not have a file extension.
  • The SECONDS() function will return the same value as the Recital function SECS().
  • If less parameters are passed to a procedure or a function then are declared with the PARAMETER statement, the extra variables are set to type UNDEFINED instead of LOGICAL.
  • If the record number qualifier of the GOTO command is less than zero or greater than the number of records, an error message is not generated and EOF() is set to TRUE and FOUND() is set to FALSE.
  • In a program the command CREATE <filename> will create an empty database with the following structure.


Field Type Length Description
FIELD_NAME Character 32 field name
FIELD_TYPE Character 1 data type of field
FIELD_LEN Numeric 3 width of field
FIELD_DEC Numeric 3 # of decimal places
FIELD_DESC Character 25 field description


  • Memory variables created with a PUBLIC or a PRIVATE statement are created with a type of UNDEFINED.
  • The SKIP 0 command flushes locked records to disk if modifications have been made. NOTE: SKIP 0 will not work this way in interactive mode.
  • The MEMOEDIT() function provides full parameter syntax compatibility with Clipper
  • The VERSION() function will have a return value of ’Clipper Summer 87’.


Example

set clipper on
create strutable
set clipper off

Products

Recital Server, Recital