Finds data within a JSON record using selection criteria. Syntax $findjson(source, argument-1, argument-2, …, argument-n) Parameters source a field, a variable, a form field or a constant containing a JSON structure argument-1 selection criteria to be searched within the specified source argument-2 secondary selection criteria to be searched within the result just found by the previous selection…
Read more
Although Zim Technology has always made the best efforts to keep compatibility between versions, technical evolution is inevitable which leads to building bridges between one existing version to the next introduced version. A brief history of Zim Technology and its migration possibilities: Conventions . OLD DATABASE: it’s the existing Zim database requiring migration; . NEW…
Read more
Viewing User Connections The User Connection utility lists all users connected to the selected Zim Server and provides an interface for disconnecting users from the server. The column headers in the User Connections grid are described in the table below: Column Description User A user identifier number, assigned by Zim Server in chronological order User Name The name of the User connected to…
Read more
ZIM Overview Zim applications consist of collections of objects, each of which has a specific purpose and a set of features. These objects are described in the Object Dictionary. These various types of objects are: The Object Dictionary is arranged such that all objects of the same type are grouped together. This is very convenient…
Read more
Zim supports the creation and manipulation of ActiveX objects and containers. An OLE or ActiveX container is used to embed the COM object into an application. Examples of a container are Visual Basic and Microsoft Word, in addition to Zim itself. OLE Container Datatype The OLE or ActiveX Container is a formfield where ft (“fieldtype”) is set to “E”. An OLE Container can either be borderless or have an OLE Object border. The OLE Object border…
Read more
An IN comparison is logically true if expression is equal to at least one of the values in the specified list. A NOT IN comparison is logically true if expression is not equal to any of the values in the specified list. In either case, the comparison ends as soon as a logically true instance is found.
The syntax of a call to a procedure is procname (expression) Parameters procname The name assigned to the procedure in its PROCEDURE or LOCALPROCEDURE command. expression Any value expression. Comments The list of expressions must be enclosed in parentheses; even when no expressions are required, the parentheses must still appear. At the prompt level, you can issue a call to the main procedure of any procedure program. Within a procedure program, you can issue a call to any…
Read more
Names for objects defined in the Object Dictionary must conform to the following conventions: The name can be from 1 to 18 characters in length. The name can contain only letters (a-z, A-Z), digits (0-9), dollar signs ($), and underscores (_). The name must begin with a letter or a dollar sign. Most names must be unique among objects of the same type in the same application…
Read more
There are two types of permissions – object permissions (EntitySets, relationships, and directories) and field-level permissions. Field level permissions take precedence over object permissions. The permissions are set as follows: The following chart summarizes the permissions needed in order to successfully execute a given form of data manipulation on an object where permissions are currently in place. Definitions are as follows: Owner refers to the user who…
Read more
Except in certain limited instances (e.g., security passwords, values held in objects of data type CHAR and VARCHAR), the software is case insensitive. Insensitivity to case means that the software makes no distinction between uppercase and lowercase letters in any part of a statement. For example, the following statements are identical, provided LastName is not a CHAR or…
Read more
English 
Portuguese