In general, SQL servers support limited indexing capabilities. Indexes can be maintained on individual columns (multi-valued or unique) and also on the concatenation of two or more columns (multi-valued or unique). In Zim terms, an indexed virtual field that corresponds to an SQL concatenated index can be represented only by an expression of the form:…
Read more
Zim supports the specification of decimal places for fields whose internal representation is in the form of integers (data types “int”, “longint” and “vastint”). This is done by maintaining the logical position of the decimal point external to the physical storage of the data. SQL servers do not do this – integer data types contain…
Read more
Indexed Fields in WHERE Clauses In Zim, developers use expressions in the form a. … WHERE >= … b. … WHERE <= … WHERE clauses retrieve data in either (a) ascending or (b) descending sequence of the data values in . This technique is used instead of an explicit sort because it takes advantage of…
Read more
The following table contains a list of the Zim constants, types, locations, and values. ConstName ConstType DirName ConstValue BlackBlueGreenCyanRedMagentaBrownLightGreyDarkGreyLightBlueLightGreenLightCyanLightRedLightMagentaYellowWhite numericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumeric ZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIM 12345678910111213141516 EscapeEsc charchar ZIMZIM ESCAPEESCAPE F1F2F3F4F5F6F7F8F9F10F11F12F13F14F15F16F17F18F19F20F21F22F23F24F25F26F27F28F29F30F31F32F33F34F35F36F37F38F39F40F41F42F43F44F45F46F47F48F49F50F51F52F53F54F55F56F57F58F59F60F61F62F63F64F65F66F67F68F69F70F71F72F73F74F75F76F77F78F79F80F81F82F83F84F85F86F87F88F89F90F91F92F93F94F95F96F97F98F99F100 charcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharchar ZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIM F1F2F3F4F5F6F7F8F9F10F11F12F13F14F15F16F17F18F19F20F21F22F23F24F25F26F27F28F29F30F31F32F33F34F35F36F37F38F39F40F41F42F43F44F45F46F47F48F49F50F51F52F53F54F55F56F57F58F59F60F61F62F63F64F65F66F67F68F69F70F71F72F73F74F75F76F77F78F79F80F81F82F83F84F85F86F87F88F89F90F91F92F93F94F95F96F97F98F99F100 HomeJumpDownJumpLeftJumpRightJumpUpPageDownPageUpTabBackTabForward charcharcharcharcharcharcharcharchar ZIMZIMZIMZIMZIMZIMZIMZIMZIM HOMEJUMPDOWNJUMPLEFTJUMPRIGHTJUMPUPPAGEDOWNPAGEUPTABBACKTABFORWARD Button1Button2Button3Button4Button5Button6 charcharcharcharcharchar ZIMZIMZIMZIMZIMZIM BUTTON1BUTTON2BUTTON3BUTTON4BUTTON5BUTTON6 CActiveBorderCActiveCaptionCAppWorkSpaceCWindowBackgroundCButtonFaceCButtonShadowCButtonTextCCaptionTextCGrayTextCHighlightColorCHighlightTextCInactiveBorderCInactiveCaptionCMenuColorCMenuTextColorCScrollBarColorCWindowFrameCWindowTextCInactivCaptionTxtCButtonHighlightCWindowColor numericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumericnumeric ZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIMZIM 373635343332313029282726252423222120191817 $CurrentODRevision$CurrentODVersioncEOLNTRANSLATE$CurrentCOVersion$CurrentDCRevision$CurrentDCVersion charcharcharcharcharchar ZIMServicesZIMServices$Utils$DevCen$DevCen$DevCen 1.06.1 11.06.1 Alt0Alt1Alt2Alt3Alt4Alt5Alt6Alt7Alt8Alt9AltAAltBAltCAltDAltEAltEqualAltFAltF1AltF10AltF11AltF12AltF2AltF3AltF4AltF5AltF6AltF7AltF8AltF9AltGAltHAltIAltJAltKAltLAltMAltMinusAltNAltOAltPAltQAltRAltSAltTAltUAltVAltWAltXAltYAltZ charcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharcharchar $DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployService$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices$DeployServices F50F41F42F43F44F45F46F47F48F49F63F76F74F65F55F52F66F31F40F83F84F32F33F34F35F36F37F38F39F67F68F60F69F70F71F78F51F77F61F62F53F56F64F57F59F75F54F73F58F72 ATTROEFTYPEATTROFOEFTYPE charchar $CompDevCen$CompDevCen…
Read more
Returns the number of members in a result set. Syntax $lastmember(setname) Parameters setname A character string or an expression that evaluates to a character string, being the name of a result set. Return Value Number with no decimal places. Comments $lastmember returns the (numerical) position of the last member in the specified result set (in…
Read more
Establishes the accelerators for the current window. Syntax WINDOW SET [ ADD|NOT] ACCELERATOR [ «keyname»] Parameters ADD Specifies that keyname is to be added to the current list of accelerator keys. NOT Specifies that keyname is to be removed from the current list of accelerator keys. keyname Can be any of the pre-defined key names:…
Read more
Selects one in a series of values. Syntax { expression1 , expression2 } Parameters expression1 any value expression expression2 any value expression Return Value The value of the first of the expressions that is not $Null. Comments The expressions within the braces are evaluated from left to right. The case expression takes the value of…
Read more
Centers a non-blank character string. Syntax $center(string) | $centre(string) Parameters string a character string, or an expression that evaluates to a character string Return Value Character string, consisting of string centered in a space $length(string) characters long. Leading or trailing blanks in string are ignored during centering. If string contains an odd number of characters,…
Read more
Calculates a date value by adding months to (or subtracting months from) a specified date value. Syntax $addmonths(date,number) where date a date, or an expression that evaluates to a DATE data type number a number, or an expression that evaluates to a number Return Value Number, representing a DATE value. Comments Use $addmonths to perform…
Read more
Tests a single Zim command, or an application program, for syntactic and semantic accuracy. Syntax PARSE commandstring | docname Parameters commandstring Any character string, enclosed in quotation marks, that represents a Zim command to be parsed. docname The name of an application document that contains an application program to be parsed. Comments The PARSE command…
Read more
English 
Portuguese