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…
Read more
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…
Read more
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…
Read more
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…
Read more
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…
Read more
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…
Read more
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.…
Read more
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…
Read more
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…
Read more
English 
Portuguese