If the Zim application being developed is based on an existing SQL database, then the Zim definition interface needs to be executed in order to import the definitions of the relevant tables from the SQL server and populate the Zim data dictionary so that the application can be developed. Conversely, if the Zim application has…
Leia mais
The return value of $DDEFunction is one of the following. A negative result indicates failure. Value Description 0 DDE service completed successfully. -1001 Bad DDE service indicator type; p2 is not of type longint or int. -1002 Unknown DDE service indicator value; p2 not 1, 2, 3, 4, or 5. -1003 Attempt to CONNECT failed.…
Leia mais
Windows Zim Server can be started manually from the Start menu, or the Startup folder. You can also start the process from the command prompt: start zsvserv.exe [-p <port number> | -s <service>] This command starts Zim Server in its own console window. The -p option sets the port number on which the server is listening. The -s option does the…
Leia mais
Errors generated during the Zim Server Connectivity activity can be checked via the system variables $SQLErrCode and $SQLErrMsg. The first one contains the error number and the second one the message text corresponding to that error number.
If you have developed an application in Zim and want to maintain a portion of the data in an SQL database, the definitions of those objects must be maintained in the SQL database as well as in Zim. Zim’s SQL definition interface translates Zim definitions into equivalent definitions in the SQL server environment. Refer to…
Leia mais
If you are developing a Zim application to run against an existing SQL database, you must create an equivalent representation of that data in Zim. Zim’s definition interface translates SQL definitions into equivalent definitions in Zim. The mapping of SQL tables to Zim EntitySets or data relationships is straight-forward. A Zim developer must first establish…
Leia mais
Zim application programs can be compiled in ZIMMODE, SERVERMODE, or SQLMODE depending the type of the data dictionary objects used (fields EntType, RelType or DocType). See details in the Zim command SET COMPILEMODE. Zim applications can operate in ZIMMODE, SERVERMODE, or SQLMODE by means of the use of the command SET EXECUTEMODE which controls the…
Leia mais
All SQL servers require that some type of connection be established between a client program and the server before any database operations can be attempted. In Zim, a connection between a Zim application and an SQL server is established by the “CONNECT” command and removed by the “DISCONNECT” command. During the execution of any Zim…
Leia mais
The use of Zim Server Connectivity in an application has an impact on performance. There are several factors to consider: Client-server configurations introduce additional overhead that is not present when an application is using a local database. The most obvious overhead is that every database request must be translated into a server request, the request…
Leia mais
Portuguese 
English