Category: ZIM 4GL Language Reference

The Original Internet Language

ZIMTCAP Defining the Terminal Characteristics

To prepare a terminal set-up that defines exactly how to produce certain Zim keyboard actions from your terminal keyboard, you must define specific keyboard information.  This information includes specific terminal usage for your specific operating system(s). Operating System-Specific Aspects of Terminal Definition Windows To run Zim under Windows no terminal keyboard definitions are required. UNIX…
Read more

REMOTEEXEC

Executes a command against a target server or executes a remote procedure on a Zim Server. Syntax 1 Parameters server Any character string expression that evaluates to “ZIMSERV”, “JDBCSAM” or an alias name representing a valid server name to which the application is already connected. expression Any value expression. Syntax 2 Parameters Server Any character…
Read more

Event

A data structure that provides information about the state of the system and the most recent event. The Event data structure provides information about the most recent event and about the state of the system when that event occurred. The components of the Event data structure are set when an event occurs in the user…
Read more

ADD

Adds data to EntitySets or relationships. Syntax #1 Adds a single record to an EntitySet or relationship. Use the LET subcommand to explicitly assign values to the target fields in the record. ADD objname [LET clause] [EVALUATE clause] [-> clause] Syntax #2 Adds one or more records from a set specification to an EntitySet or…
Read more

CHANGE

Changes data in EntitySets, relationships, forms, or result sets. Syntax #1 Changes specific fields in one or more records in an EntitySet, relationship, form, or set. The existing values in target fields are changed to specified values. The LET subcommand explicitly assigns values to the target fields. Only fields explicitly named in the LET subcommand…
Read more

Reserved Characters and Words

Certain characters and words are reserved for special purposes in the Zim software. Reserved Characters These characters are sometimes called meta-characters. Reserved characters include quotation marks (” and ‘) that define and enclose character strings spaces that are the default field separator (delimiter) backslashes () that escape other characters percent signs (%) that mark the…
Read more

UPDATE

Changes data in EntitySets, relationships, forms, or sets. Syntax UPDATE [ALL] [SQLsetspec] SET «field = value » [WHERE clause [EVALUATE clause] [-> clause] Parameters ALL Optional. Regardless of whether ALL is entered, all records in the set specification that meet the specified condition (if any) are updated. SQLsetspec An SQL set specification. Can contain application…
Read more

INSERT

Adds a single record to EntitySets or relationships ( ISQL option only). Syntax INSERT INTO object [( field)] VALUES(expr1 | NULL) [EVALUATE clause] [clause] Parameters object The name of an EntitySet or relationship with fields to which you want to add a record. A role name can be used. field A target field in object.…
Read more

SELECT

Lists selected data from the database. Syntax SELECT [ALL] [DISTINCT] values FROM SQLsetspec [-> setname] Parameters ALL An optional keyword indicating that all records of the specified type are to be listed. But, even if ALL is omitted, all records are processed by default. DISTINCT Specifies that only the records that contain unique values in…
Read more

USING

USING In a set specification, qualifies a relationship. Syntax relationship («USING obj1 AS obj2») Parameters relationship The name of the relationship being qualified. obj1 The name of an object used elsewhere in the set specification in which relationship appears. Must be the name or role name of an EntitySet, relationship, form, or application document. Must…
Read more

en_CAEnglish