Marks the end of a procedure.
Syntax
ENDPROCEDURE
Comments
ENDPROCEDURE is used only in conjunction with a LOCALPROCEDURE or PROCEDURE command. It is the last command of a procedure in an application program.
Marks the end of a procedure.
ENDPROCEDURE
ENDPROCEDURE is used only in conjunction with a LOCALPROCEDURE or PROCEDURE command. It is the last command of a procedure in an application program.
Starts an explicit transaction.
BEGIN WORK
This command is the SQL equivalent of the TRANSACTION command.
Indicates a negative value (unary -) or subtracts one value from another.
[expression1] – expression2
The minus sign (-) subtracts the expression on the right from the expression on the left.
where
expression1 | a number or expression that evaluates to a number |
expression2 | a number or expression that evaluates to a number |
Arithmetic operators indicate the sign of a number or perform arithmetic operations (addition, subtraction, multiplication, division, exponentiation).
Performs real-time and on-line backups of Zim databases.
[nohup] zimbackup [-k] &
[start] zimbackup [-k]
-k | optional parameter to stop Zim Backup Server |
Zim Backup Server, working together with Zim Server, performs a real-time, online backup of any databases being serviced by Zim Server.
All modifications performed by Zim Server in a given database are subsequently applied to a copy of the database so that, in fact, there are two “live” databases, one which is the real database that Zim Server is managing to serve all users and a second one, which is an exact copy of the first one.
If something happens to the real database, Zim Backup Server can be stopped in the copy database, Zim Server can immediately start running in this copy database and users can reestablish their Zim sessions.
Before starting servicing users, Zim Server applies committed transactions to the backup database and then opens access to users.
Zim Backup can be stopped at any moment and let the backup databases be copied to another place. Later, Zim Backup can be restarted and all modifications to the real databases are applied in succession to the backup databases.
For operational details, refer to Database Backup.
Sends a bitmap image of the screen to print; output is sent to either the clipboard or the standard output printer.
$screenprint()
Returns “1” ($True) if no errors were detected before the print job was submitted. Otherwise, returns “0” ($False).
Ends a transaction and writes all updates to the database.
COMMIT WORK
This command is the SQL equivalent to the ENDTRANSACTION command.
Controls if virtual fields can be output using a LIST command.
SET OUTPUT VIRTUALFIELD ON|OFF
The OUTPUT VIRTUALFIELD option is set ON by default.
Normally, LIST can output virtual fields. To suppress the output of virtual fields, set OUTPUT VIRTUALFIELD to OFF.
See Also
Obtain the oldest event generated by a COM component.
$ObjGetEvent (Object)
Object | an object variable or formfield of type OLE |
Returns a result as per the specification of the object.
Note: Zim attempts to convert to the assigned type. Ensure a proper variable type is assigned.
COM objects can generate synchronous or asynchronous events. In any case, they will be stacked up until removed by a $ObjGetEvent function invocation. Later, the parameters associated to this event can be queried using the $ObjEventParameter function.
Is up to the programmer’s responsibility to know whether the object raises events and what is the structure of these events.
This example creates a component, runs a specific method and then queries the events by retrieving its parameters:
let vObject = $ObjCreate('MyObject.Anything') let vResponse = $ObjRunMethod(vObject, 'MyMethod', 'AParameter') let vResponse = $ObjGetEvent(vObject) if ($ObjEventName = 'MyEvent') out $objeventparameter(1) out $objeventparameter(2) else ... endif let vResponse = $ObjDestroy(vObject)
COM objects are being discontinued by Microsoft and may not be available in future releases of Zim-X.
Identifies the software that is currently being used.
$zimversion
A number. Cannot be reset by an application program.
The version number of the software currently being used (e.g., 5.002).
The error code returned from the SQL database.
$sqlerrcode
A number. Can be reset by an application program.
A numeric code returned from the SQL database for the last SQL statement executed. For explanation of these error codes, consult the documentation for the particular SQL server.