ZIM Language Reference

Commands

• { } (Case)
• $HelpFile
• ACCESS
• ADD
• AFT
• AND
• Boolean Expressions
• BOTTOM
• BREAK (Loops)
• BREAK (Reports)
• BYE
• CASE
• Case Sensitivity
• CFT
• CHANGE
• CLEAR
• COLUMN BREAK
• COMPILE
• COMPUTE
• Conditional Expressions
• CONNECT
• CONTINUE
• CREATE
• CREATE MEMORY SET
• CURSOR
• Data Types
• Database Backup and Restoration
• DECRYPT
• DELETE
• DEPENDENCY
• DESCERR
• DETAIL LINE
• DISCONNECT
• DISPOSE
• DOWN
• EDIT
• ELSE
• ELSEIF
• ENCRYPT
• ENDCASE
• ENDIF
• ENDON
• ENDPROCEDURE
• ENDREPORT
• ENDTRANSACTION
• ENDWHILE
• ERASE
• Event
• EXPLERR
• FIND
• GENERATE
• GOTO
• GOTO NEXT
• GOTO PREVIOUS
• GRAPH
• HALT
• HELP
• How To Call Procedures
• How To Name Objects
• How to Use the Report Generator
• How To Use Value Expressions
• How To Use Variables
• IF
• IN
• INITIALIZE
• INPUT
• LET
• LIST
• LOCALPROCEDURE
• LOCATE
• LOGIN
• Macros
• NEXT
• NOT
• Object permissions
• ON
• OTHERWISE
• OUTPUT
• Output Masks
• PAGE FOOTING
• PAGE HEADING
• PAGE LEFT
• PAGE RIGHT
• PARSE
• PASSWORD
• PAUSE
• PERMISSION
• Predefined Color Constants
• PREVIOUS
• PRINT
• PRINT REPORT
• PROCEDURE
• Program Templates and the GENERATE Command
• QUITTRANSACTION
• RELEASE
• REMOTEEXEC
• RENAME
• REPORT FOOTING
• REPORT FROM
• REPORT HEADING
• Report Item Format Options
• Reserved Characters and Words
• RESET CONNECTOR DOCUMENT
• RETURN
• RightClick
• SCREEN CLEAR
• SCREEN RESET
• Securing Data Inside an Application
• SERVBYE
• SERVPROF
• SET EXCEPTION
• SLEEP
• SORT
• STOP
• SYSTEM
• System Variables
• TOP
• TRANSACTION
• TRANSFORM
• UNCOMPILE
• UP
• WHEN
• WHILE
• Zim Constants
• ZIMBACKUP
• ZIMEXPLORE
• ZIMTCAP Defining the Terminal Characteristics
• ZIMXTEND (File Extender)
Show all articles ( 118 ) Collapse Articles

Forms Handling Commands

• DISPLAY DEFINE
• FORM CLEAR
• FORM CLOSE
• FORM DEFINE
• FORM DISPLAY
• FORM INPUT
• FORM OPEN
• FORM REPORT
• FORM RESTORE
• FORM SAVE
• FORM SCROLL
• FORM SET
• FORM SET DYNAMICLIST
• FORM SET FOCUS
• FORM SET INPUT
• FORM SET LIST
• FORM SET MOUSEPOINTER
• FORM SET SAVE
• FORM SET SCROLL
• MENU CLEAR
• MENU CLOSE
• MENU DEFINE
• MENU DISPLAY
• MENU INPUT
• MENU OPEN
• MENU SET
• MENU SET TOOLBAR
• OLE Container Support
• WINDOW ACTIVATE
• WINDOW CLEAR
• WINDOW CLOSE
• WINDOW DEACTIVATE
• WINDOW DEFINE
• WINDOW DEFINE
• WINDOW DISPLAY
• WINDOW MOVE
• WINDOW OPEN
• WINDOW SCROLL
• WINDOW SET
• WINDOW SET ACCELERATOR
• WINDOW SET CURRENT
• WINDOW SET CURSOR
• WINDOW SET INPUT
• WINDOW SET INPUT EXPOSE
• WINDOW SET MOUSEPOINTER
• WINDOW SET OUTPUT
• WINDOW SET SCROLL
• WINDOW SIZE
• WINDOW STATUS
Show all articles ( 39 ) Collapse Articles

Functions

• $absolute
• $acos
• $adddays
• $addhours
• $addminutes
• $addmonths
• $addseconds
• $addticks
• $addweeks
• $addyears
• $and
• $ansitodos
• $asin
• $atan
• $atan2
• $average
• $center
• $compilestatus
• $concat
• $copytoclient
• $copytoserver
• $cos
• $cosh
• $count
• $currentmember
• $day
• $dayname
• $DBName
• $delete
• $dirpath
• $distinct
• $dostoansi
• $ESCAPEXML
• $Exist$
• $exp
• $fieldnum
• $filebrowse
• $filenum
• $filepath
• $fileprint
• $fill
• $fromblob
• $getproperty
• $hours
• $insert
• $isalphabetic
• $isalphanumeric
• $IsConnected
• $isdate
• $isdigit
• $islower
• $isnumber
• $isodd
• $isupper
• $iswinopen
• $iszimname
• $lastmember
• $left
• $leftjustify
• $length
• $log
• $log10
• $ltrim
• $mask
• $max
• $maxof
• $MD5
• $messagebox
• $min
• $minof
• $minutes
• $modulus
• $money
• $month
• $monthname
• $not
• $ObjCreate
• $ObjDestroy
• $ObjErrCode
• $ObjErrDescription
• $ObjErrHelpFile
• $ObjErrHelpTopic
• $ObjErrObjectType
• $ObjErrParameter
• $ObjEventName
• $ObjEventParameter
• $ObjException
• $ObjGetEvent
• $ObjGetProperty
• $ObjRunMethod
• $ObjSetProperty
• $or
• $position
• $printersetup
• $random
• $replace
• $right
• $RightClickMenu
• $rightjustify
• $round
• $screenprint
• $screensave
• $seconds
• $ServerFunction
• $setproperty
• $sin
• $sinh
• $soundex
• $SQLPath
• $sqrt
• $squeeze
• $StartPath
• $subscript
• $substring
• $tan
• $tanh
• $ticks
• $toalpha
• $tocharacter
• $tochr
• $todate
• $tolower
• $tonumber
• $toord
• $total
• $toupper
• $translate
• $transmitkey
• $trim
• $truncate
• $ttrim
• $UserFunction
• $UserPath
• $value
• $weekday
• $year
• $ZimSeqNum
Show all articles ( 127 ) Collapse Articles

System Variables

• $BreakFlag
• $ClientOS
• $ClipPath
• $CursorCol
• $CursorRow
• $CursorScreenCol
• $CursorScreenRow
• $Date
• $DBCharSet
• $DBPath
• $DeadlockReason
• $Direction
• $Editor
• $ErrCode
• $ErrLevel
• $False
• $Graphics
• $GroupID
• $ImagePath
• $InTransaction
• $LastErrCode
• $LastErrLevel
• $LastErrMessage
• $LineNumber
• $Located
• $MaxErrLevel
• $MemberCount
• $Null
• $Page
• $ProgramFileName
• $ProgramName
• $ScreenHeight
• $ScreenWidth
• $SetCount
• $SQLErrCode
• $SQLErrMsg
• $Time
• $TimeSecs
• $True
• $UserID
• $WindowPSHeight
• $WindowPSWidth
• $WorkPath
• $ZGroupID
• $ZimOS
• $ZimPath
• $ZimProduct
• $ZimVersion
• $ZUserID
• Event
• System Variables
• ThisForm
• ThisMenu
• ThisWindow
Show all articles ( 44 ) Collapse Articles

SET Commands

• SET (EntitySet/Data Relationship Attribute)
• SET (Field Attributes)
• SET AUTORETRY
• SET BREAKABLE
• SET CHECKNULLS
• SET CHECKPOINT
• SET CHECKSETS
• SET COLUMNSPACING
• SET COMMANDTIMING
• SET COMPILEMODE
• SET CONNECTOR DOCUMENT
• SET CURRENTSET
• SET CURSOR
• SET DATABASE ACCESS
• SET DECIMALS
• SET DELIMITER
• SET DEPENDENCY
• SET DOCLINELENGTH
• SET DOCUMENT FORMAT
• SET EOFVALUE
• SET EOLNTRANSLATE
• SET ERRORS
• SET ESCAPECHAR
• SET EXECUTEMODE
• SET FLOW
• SET FOR UPDATE
• SET HEADINGS
• SET IMPLICITTRANS
• SET INFORMATION
• SET INPUT FORMAT
• SET INPUT TIMEOUT
• SET LEXTRACE
• SET MEMBERCOUNT
• SET MEMBERINTERVAL
• SET MESSAGES
• SET MESSAGES WINDOW
• SET MOUSE
• SET NULLVALUE
• SET OUTPUT
• SET OUTPUT FIELDLISTWIDTH
• SET OUTPUT FORMAT
• SET OUTPUT MASKFIELD
• SET OUTPUT TRIM
• SET OUTPUT VIRTUALFIELD
• SET PAGESIZE
• SET PAGEWIDTH
• SET PAUSE
• SET QUOTING
• SET RESET
• SET RESTORE
• SET RUNTIME
• SET SAVE
• SET SELECTIVITY
• SET SEQUENCENUMBER
• SET SINGLESTEP
• SET SIZE
• SET SPECIALSCAN
• SET SQLCOMPILE
• SET SQLTRACE
• SET STOP ERRORS
• SET STRATEGY
• SET TEXTDELIMITER
• SET TIMEOUT
• SET TRACE
• SET TRACEOUTPUT
• SET TRANSACTION DEFAULTTYPE
• SET TRANSACTION FLOW
• SET VALIDDATE
• SET WARNINGS
• SET XML ROWELEMENT
• SET XMLHEADER
• SET XREF
Show all articles ( 62 ) Collapse Articles

Subcommands

• -> (Dynamic Rename)
• -> (Result Set)
• COMPLETE
• EVALUATE
• INTERSECT
• KEEP
• MINUS
• Set Specification
• Set Specification (ISQL)
• SORTED BY
• UNION
• UNRELATED
• USING
Show all articles ( 3 ) Collapse Articles

Metacharacters

• ? (Wildcard)
• \ (Escape)
• #(Macro call)
• % (Comment)
• % (Wildcard)
• < > (Macro name delimiters)
• <<>> (Program template delimiters)
• $ (Template line join)

Operators

• ^ (Exponent)
• - (Subtract/Negative)
• ( ) Parentheses
• [NOT] BETWEEN
• [NOT] IN
• [NOT] LIKE
• * (Multiply)
• / (Divide)
• + (Add/Positive)
• =, <, <=, <>, >, >= (Condition)
• IS [NOT] [$]NULL
• OR
• WHERE
• XOR
Show all articles ( 4 ) Collapse Articles

SQL Commands

• BEGIN WORK
• COMMIT WORK
• DELETE FROM
• INSERT
• ROLLBACK WORK
• SELECT
• UPDATE
• WHERE (Condition)

DDE Services

• $DDEFunction
• DDEConnect
• DDEDisconnect
• DDEExecute
• DDEPeek
• DDEPoke