Zim supports Microsoft Open Database Connectivity Drivers (ODBC, defined by Microsoft as a standard way for applications to access data stored in database files) which allows third-party tools to access a Zim database via the Zim ODBC Driver. This driver is used to access data from a Zim database that is either local to the…
Read more
Note: In Zim, constant strings can be represented either surrounded in single quotes (‘) or double quotes (“). In SQL, constant strings are surrounded by single quotes (‘) whereas identifiers are surrounded by double quotes (“). statement ::= SELECT select | INSERT insert | DELETE delete | UPDATE update | passthroughSQL passthroughSQL ::= any statement…
Read more
An ODBC Data Source to access a Zim database can be configured in two different ways: . Using the Zim ODBC Driver Setup to create a data source; . Using Zim language to dynamically create and maintain a data source tailored for specific needs like calling a third party software from within Zim. In both…
Read more
If the server function requires parameters (called input host variables), these can be supplied by placing parameter markers in the syntax (indicated with a ‘?’) and then specifying the parameters as the second and subsequent arguments to $ServerFunction. Here is an example: change all orders where orderno = 1003 \ let RequiredByDate = $ServerFunc(‘trunc( ?,…
Read more
The various XML technologies incorporated into ZimWeb may require references from one source to another (e.g. one XSLT stylesheet referencing another, or a reference to an external image in XSL-FO). The following explains precisely how references to other sources (URIs) are interpreted in different circumstances. URIs in XML generated by the Zim database agent…
Read more
Key Guidelines for Creating Secure ZimWeb Applications Secure access to the ZimWeb Administration servlet such that unpriviledged users cannot access it.The installation instructions for Tomcat (See Installation) show how to reserve it for a given user name and password. Ensure that the client DEBUG facility is disabled by default by setting the allow-debug configuration option…
Read more
Adding More Power and Flexibility to Zim Zim is a powerful and flexible environment for developing and using all types of database applications. Zim‘s Entity-Relationship (ER) data model and fully-integrated Object Dictionary enable progressive program development, whether the information processing system is simple or complex. Zim Server provides a database server capability that can be…
Read more
ZimWeb includes page template support. This allows you to combine parameters from Zim with the page (web page, etc.) delivered to the client. Template file format A page template is just a regular page (HTML etc.), with parameter placeholders to indicate where each parameter to be supplied by the Zim application is to be placed.…
Read more
ZimWeb Connection Architecture Web applications can be implemented in Zim, using a Java Servlet program called ZIIServlet, provided as part of ZimWeb. A Java Servlet must be executed on a Java Servlet Container, such as Apache’s Jakarta Tomcat. ZIIServlet works together with Zim Server to process requests from the client, whose interaction with the end…
Read more
XML Technologies The following books will be particularly useful in explaining the XML technologies that are crucial to using the ZimWeb effectively: XML By Example (2nd Edition) and Applied XML Solutions by Benoit Marchal – these will give you a good overview of the XML landscape. XSLT Programmer’s Reference 2nd Edition by Michael Kay…
Read more
English 
Portuguese