Category: SET Commands

The Original Internet Language

SET QUOTING

Specifies if quotation marks are required for character strings. Syntax SET QUOTING ON|OFF Comments The QUOTING option is set OFF by default. Setting QUOTING ON causes the software to issue a warning message each time it encounters a non-numeric character string not enclosed in quotation marks (i.e., unquoted character strings that are valid numbers do…
Read more

SET FLOW

Controls the call tracing of procedures. Syntax SET [LOCAL] FLOW ON|OFF Parameters LOCAL The command is to take effect only within the current procedure. Comments Call tracing messages show shifts in execution control from one procedure to another. The SET FLOW command controls call tracing. FLOW is OFF by default. When FLOW is ON, the…
Read more

SET SIZE

Sets the estimated number of records in an EntitySet, relationship, application document, or result set. Syntax #1 SET SIZE object size or SET object SIZE size Parameters object The name of an EntitySet, a relationship with fields, a structured application document, or a result set. size A positive number representing the estimated number of records…
Read more

SET COMPILEMODE

SET COMPILEMODE Controls the behavior of the Compiler. Syntax SET COMPILEMODE SQLMODE | ZIMMODE | SERVERMODE Comments The COMPILEMODE option is set to SQLMODE by default. The compiler generates SQL database code—that is, code bound to a particular SQL database type. In ZIMMODE, EntType, RelType, and so on, are ignored. The compiler generates standard Zim…
Read more

SET DELIMITER

Specifies the current field delimiter. Syntax SET DELIMITER character Parameters character Any valid character. The space, forward slash, comma, and quotation mark are the most commonly used. If character is not a letter or a digit, it must be enclosed in quotation marks. If character is a special character such as space or backslash, it…
Read more

SET MEMBERCOUNT

Turns set-processing messages on and off. Syntax SET MEMBERCOUNT ON|OFF Comments When MEMBERCOUNT is set ON, messages tracking the progress of set-processing commands are output. Messages overwrite each other at intervals specified by the SET MEMBERINTERVAL command. Progress messages take the form nnn processed. Messages are output with a carriage return but with no line…
Read more

SET DEPENDENCY

Specifies if dependencies between objects are to be tracked. Syntax SET DEPENDENCY ON|OFF Comments The DEPENDENCY option is set ON by default. When DEPENDENCY is ON, dependency information is stored when you CREATE, ERASE, or RENAME an object in the Object Dictionary. (For example, creating a relationship establishes dependencies between the relationship, the objects being…
Read more

SET COLUMNSPACING

Controls the spacing between columns in the output of LIST and OUTPUT commands. Syntax SET COLUMNSPACING num Parameters num Num can bean integer constant (e.g., 15, 200),a variable, form field, menu item, or parameter that evaluates to an integer,A setting of zero is valid. Comments The COLUMNSPACING option is set to 1 by default. The…
Read more

SET VALIDDATE

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

SET BREAKABLE

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

en_CAEnglish