Difference between revisions of "SET CLIPPER5"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
(2 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
==Purpose== | ==Purpose== | ||
Support added Clipper 5 compatibility | Support added Clipper 5 compatibility | ||
Line 15: | Line 8: | ||
==See Also== | ==See Also== | ||
− | [[ | + | [[ASTORE()]], [[CREATE]], [[DB_FOXPLUSBUGS]], [[DB_FOXPROKEYS]], |
− | + | [[EDITFIELD()]], [[EOF()]], [[FILE()]], [[FILETYPE()]], [[FOUND()]], [[GOTO]], [[INDEXEXT()]], [[MEMOEDIT()]], [[PARAMETERS]], [[PRIVATE]], [[PUBLIC]], [[SECONDS()]], [[SECS()]], [[SET CLIPPER]], [[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== | ==Description== | ||
Line 23: | Line 16: | ||
When SET CLIPPER5 is ON the following will be in effect: | When SET CLIPPER5 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 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 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(). | + | * The SECONDS() function will return the same value as the Recital function SECS(). |
− | If fewer parameters are passed to a procedure or a function than are declared with the PARAMETER statement, the extra variables are set to type UNDEFINED instead of LOGICAL. | + | * If fewer parameters are passed to a procedure or a function than 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. | + | * 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. | + | * In a program, the command CREATE <filename> will create an empty database with the following structure. |
− | {| | + | |
− | + | {| class="wikitable" | |
+ | !Field||Type||Length||Description | ||
|- | |- | ||
|FIELD_NAME||Character||32||field name | |FIELD_NAME||Character||32||field name | ||
Line 50: | Line 44: | ||
|} | |} | ||
− | |||
− | The SKIP 0 command flushes locked records to disk if modifications have been made. | + | * Memory variables created with a PUBLIC or a PRIVATE statement are created with a type of UNDEFINED. |
− | NOTE: SKIP 0 will not work this way in interactive mode. | + | |
+ | * 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 5’. | |
− | The VERSION() function will have a return value of ’Clipper 5’. | + | |
− | Curly braces ’{}’ are interpreted as array size definition separators, not date delimiters. | + | * Curly braces ’{}’ are interpreted as array size definition separators, not date delimiters. |
==Example== | ==Example== | ||
− | < | + | <code lang="recital"> |
set clipper5 on | set clipper5 on | ||
create strutable | create strutable | ||
− | set clipper5 off</ | + | set clipper5 off</code> |
==Products== | ==Products== | ||
− | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|CLIPPER5]] | [[Category:Set_Commands|CLIPPER5]] |
Latest revision as of 16:52, 12 November 2009
Purpose
Support added Clipper 5 compatibility
Syntax
SET CLIPPER5 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 CLIPPER, 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 5 behavior and Recital behavior. This SET command has been implemented to compensate for the differences between the Recital and Clipper 5 4GLs.
When SET CLIPPER5 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 fewer parameters are passed to a procedure or a function than 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 5’.
- Curly braces ’{}’ are interpreted as array size definition separators, not date delimiters.
Example
set clipper5 on create strutable set clipper5 off
Products
Recital Server, Recital