613-518-1166 info@zimdatabases.com

ZIM Language Reference

Reserved Characters and Words

< All Topics

Certain characters and words are reserved for special purposes in the Zim software.

Reserved Characters

These characters are sometimes called meta-characters. Reserved characters include

  • quotation marks (” and ‘) that define and enclose character strings

  • spaces that are the default field separator (delimiter)

  • backslashes () that escape other characters

  • percent signs (%) that mark the start of a comment

  • question marks (?) that, when not in quotation marks, are a wildcard indicator

  • braces ({ and }) that mark and enclose case expressions

  • Reserved Words

    You cannot use any reserved word as a database, application, or filename in Zim. Reserved words include

  • any automatically generated filename in the form

  • prefix_99999

    where prefix is a name automatically generated by Zim

  • the strings, words, command and function names found in the following table

  • $absolute

    $toupper

    inout

    $acos

    $tovirtual

    input

    $adddays

    $translate

    insert

    $addhours

    $trim

    intersect

    $addminutes

    $truncate

    into

    $addmonths

    $ttrim

    is

    $addseconds

    $userfunction

    keep

    $addticks

    $usrfn1

    label

    $addweeks

    $usrfn2

    leftmargin

    $addyears

    $usrfn3

    let

    $and

    $value

    level

    $ansitodos

    $weekday

    li

    $asin

    $wrap

    like

    $atan

    $year

    line

    $atan2

    access

    list

    $average

    across

    local

    $browsefile

    activate

    localprocedure

    $center

    add

    locate

    $centre

    all

    login

    $chop

    always

    mask

    $compilestatus

    and

    max

    $concat

    any

    maximize

    $cos

    append

    menu

    $cosh

    as

    messages

    $count

    ascending

    method

    $currentmember

    at

    min

    $day

    avg

    minimize

    $dayname

    background

    minus

    $ddefunction

    begin

    mousepointer

    $delete

    between

    move

    $dirpath

    border

    newline

    $distinct

    bottom

    newpage

    $dostoansi

    bottommargin

    next

    $errmsg

    breakable

    noprint

    $eventparameter

    bye

    not

    $exist$

    call

    null

    $exp

    case

    objectevent

    $filebrowse

    center

    off

    $filenum

    centre

    oldline

    $filepath

    change

    on

    $fileprint

    class

    open

    $fill

    clearscreen

    or

    $fn

    close

    order

    $getproperty

    column

    otherwise

    $hours

    columnbreak

    output

    $insert

    columnspacing

    owner

    $isalphabetic

    commit

    page

    $isalphanumeric

    compile

    pagelines

    $isdate

    complete

    pagesize

    $isdigits

    compute

    pagewidth

    $islower

    connect

    parse

    $isnumber

    const

    password

    $isnumeric

    constant

    pause

    $isodd

    continue

    pencolor

    $isupper

    count

    permission

    $iswinopen

    create$$

    pointsize

    $iszimname

    currentset

    previous

    $java

    cursor

    print

    $lastmember

    deactivate

    procedure

    $left

    deadlock

    prompt

    $leftjustify

    decrypt

    quittransaction

    $length

    defaulttype

    read

    $log

    define

    relationship

    $log10

    delete

    release

    $ltrim

    dependency

    remoteexec

    $mask

    descending

    rename

    $max

    detail

    report

    $maxof

    directory

    required

    $messagebox

    disconnect

    reset

    $min

    display

    restore

    $minof

    dispose

    return

    $minutes

    distinct

    right

    $modulus

    document

    role

    $money

    down

    rollback

    $month

    dynamiclist

    save

    $monthname

    edit

    screen

    $not

    else

    scroll

    $null

    elseif

    selectivity

    $objcreate

    encrypt

    serverexec

    $objdestroy

    end

    set

    $objgetproperty

    endcase

    size

    $objrunmethod

    endclass

    sleep

    $objsetproperty

    endif

    some

    $objstatus

    endmethod

    sorted

    $objsubroutine

    endon

    spaces

    $oleinsertdialog

    endprocedure

    span

    $oleobjectattrs

    endreport

    startcase

    $or

    endtransaction

    statusbartext

    $pagesetup

    endwhile

    stop

    $paintfunction

    ent

    sum

    $position

    enter

    suppress

    $printersetup

    entityset

    system

    $random

    erase

    to

    $replace

    errors

    toolbar

    $replicate

    evaluate

    top

    $right

    exception

    topmargin

    $rightclickmenu

    exec

    transaction

    $rightjustify

    exists

    transform

    $round

    expose

    transmit

    $screenprint

    field

    trim

    $screensave

    fillcolor

    uncompile

    $seconds

    find

    underline

    $sendtoserver

    fld

    union

    $serverfunction

    flow

    unrelated

    $setproperty

    focus

    up

    $sin

    font

    update

    $sinh

    fontsize

    using

    $sn

    footing

    values

    $soundex

    for

    variable

    $sqrt

    foreground

    verb

    $squeeze

    form

    warnings

    $substring

    format

    wh

    $sysdirid

    from

    width

    $sysseqno

    functionkeys

    when

    $tan

    generate

    where

    $tanh

    goto

    while

    $ticks

    graph

    width

    $toalpha

    group

    window

    $tocharacter

    having

    work

    $tochr

    headings

    wrap

    $todate

    help

    xor

    $tolower

    hide

    xref

    $tonumber

    if

     

    $toord

    immediately

     

    $total

    in

     

     

    Was this article helpful?
    0 out Of 5 Stars
    5 Stars 0%
    4 Stars 0%
    3 Stars 0%
    2 Stars 0%
    1 Stars 0%
    How can we improve this article?
    Table of Contents