Calculates a date value by adding years to (or subtracting years from) a specified date value.
Syntax
$addyears(date,number)
Parameters
| date | a date, or an expression that evaluates to a DATE data type |
| number | a number, or an expression that evaluates to a number |
Return Value
Number, representing a DATE value.
Comments
Use $addyears to perform arithmetic with date values. The $addyears function calculates a date value by adding a number representing years to a date value. If number is negative, the effect is to subtract the years from the date.
The + (add) and – (subtract) operators can be used to achieve the same results.
If date or the result of the $addyears expression is an invalid date (e.g., 19930231), it is adjusted to produce a valid date (e.g., 19930228).
Example
If $Date has the value 19981225, then
$addyears($date,5)
Evaluates to 20041225.
$addyears($date,-5)
Evaluates to 19931225.
$addyears(19980229,1)
Evaluates to 19990228.
See Also
$adddays
$addmonths
$addweeks
$todate
$weekday
$year
+ (Add/Positive)
– (Subtract/Negative)
About Functional Expressions
Arithmetic with Dates
Sets the minimum acceptable date.
Syntax
SET VALIDDATE min_date
Parameters
| min_date | The minimum acceptable date (e.g. 19000101) |
Comments
Example
By default, the minimum acceptable date in Zim is 0. The following assignments are accepted without warnings
>let nDate = 0.
>let pDate = 19991231.
>let qDate = 20010101.
However, when the minimum acceptable date is set to 20000101, the first two assignments generate warnings:
>let nDate = 0.
*** Warning *** DATE value is invalid but the operation was performed.
>let pDate = 19991231.
*** Warning *** DATE value is invalid but the operation was performed.
The following assignment executes without warnings:
>let qDate = 20010101.
Controls the availability of the “break” key to the application user.
Syntax
SET BREAKABLE ON|OFF
Comments
The BREAKABLE option is set ON by default.
When BREAKABLE is ON, the application user may press the “break” key to terminate any command being executed. SET BREAKABLE OFF instructs the software to ignore the signal generated by the terminal “break” key.
The SET BREAKABLE command is not affected by the SET RESET and SET RESTORE commands.
See Also
$BreakFlag
Specifies how the FieldMask is treated in a LIST command.
Syntax
SET OUTPUT MASKFIELD ON|OFF
Comments
The OUTPUT MASKFIELD option is set ON by default.
Normally, the FieldMask is used to format data output from the database using the LIST command. To suppress the FieldMask, set OUTPUT MASKFIELD to OFF.
The OUTPUT MASKFIELD setting is unaffected by the SET SAVE and SET RESTORE commands.
See Also
LIST
Output Masks
Traces the execution of explicit transaction commands.
Syntax
SET TRANSACTION FLOW ON|OFF
Comments
The execution of explicit transactions (implemented using TRANSACTION, ENDTRANSACTION, and QUITTRANSACTION commands) is traced through the display of special messages, even in single-user systems.
Implicit transactions are not traced.
See Also
$InTransaction
ENDTRANSACTION
QUITTRANSACTION
SET TRACEOUTPUT
TRANSACTION
Controls the use of a pointing device in Zim for Windows.
Syntax
SET MOUSE ON|OFF
Comments
The MOUSE option is set ON by default.
When MOUSE is ON, the use of a pointing device is enabled for the client area of Zim windows. The application can then respond to mouse-button accelerators that occur while the focus is in a window.
The SET MOUSE command has no effect on standard windows. In such windows, it is assumed that a pointing device is active at all times, when available.
See Also
Event
FORM INPUT
MENU INPUT
Controls the use of the escape character in quoted character strings.
Syntax
SET ESCAPECHAR ON|OFF
Comments
The ESCAPECHAR option is ON by default.
When ESCAPECHAR is ON, the backslash is treated as the escape character inside quoted character strings. Setting ESCAPECHAR to OFF causes the backslash to be treated as data. The OFF setting is particularly useful in operating environments where the backslash character is used as the path separator character.
See Also
\ (Escape)
Sets the format of the application document.
Syntax
SET DOCUMENT FORMAT UTF-8|ANSI|DBCHARSET
Parameters
| UTF-8 | Selects the UTF-8 character set and writes a UTF-8 BOM at the beginning of the file. |
| ANSI | Selects the ANSII character set. |
| DBCHARSET | Selects the character set used by the current database. |
Comments
Identifies the character set used by application documents.
See Also
$DBCharSet
Activates or deactivates the use of the message window for system messages.
Syntax
SET MESSAGES WINDOW ON|OFF
Comments
The MESSAGES WINDOW option is set OFF by default.
When MESSAGES WINDOW is OFF, system messages are displayed line-by-line in the application window (BACKSCREEN). By setting MESSAGES WINDOW ON, you enable a pop-up window for the display of all system messages that are not currently suppressed.
See Also
SET ERRORS
SET INFORMATION
SET MESSAGES
SET OUTPUT
SET WARNINGS
Makes a specified result set the current set.
Syntax
SET CURRENTSET setname
Parameters
| setname | The name of an existing result set. |
Comments
Normally, the current set is the result set produced as a result of the last FIND command executed. SET CURRENTSET enables you to select another existing result set to use as the current set.
The SET CURRENTSET command takes effect immediately upon parsing or compilation, not just when the compiled program is executed.
The SET CURRENTSET command is not affected by the SET RESET and SET RESTORE commands.
Example
procedure test3 (a,b)
if a = b
find Employees -> EmpSet
else
find Departments -> DeptSet
endif
if a = b
set currentset EmpSet
let a = LastName
endif
The SET CURRENTSET command ensures that the correct set is recognized as the current set.
Portuguese 
English