DC 12.1 | Scripting Keywords

User Guide > Scripting > Writing Expressions > Scripting Keywords

Was this helpful?

Scripting Keywords

The scripting language encompasses functions, statements, and keywords that are used in source and target filters, target field expressions, and scripts. It also employs many unique functions, which were designed to help you get the most out of your data. You may recognize VBScript, some Visual Basic functions, and some SQL statements.

Category	Keywords
Array Handling	IsArray function
	Declaration (Dim, Static, etc.)
	LBound
	UBound
	ReDim
	DJRowSet object type
Assignment	Let, Set statements
Comments	(apostrophe): Comment out one line of code
Comments	CStyle: Comment out a block of code
Constants/Literals	Empty, Nothing, Null
	True, False
	User-defined literals
Flow Control	For. . . Next, For Each...Next statements
	While. . . Wend statement
	If. . . Then. . . Else statement
	Select. . . Case statement
	Function statement
Conversion	Abs, Asc, Chr functions
	CBool, CByte functions
	CDate, CDbl, CInt functions
	CLng, CSng functions
	Fix, Int, Sgn functions
	Bin, Hex, Oct functions
Internal Objects	DJExport, DJImport objects
	DJField, DJRecord objects
	Err, Sys objects
Data type	Integer, Long, Single, Double
Data type	String (must be declared ByVal)
Date/Time	Tip... For date and time values, we recommend using the DateValMask Function in EZscript Script Editor for better format conversion results. CDate, Date, Time functions
	Day, Month, Weekday, Year functions
	Hour, Minute, Second functions
	Now, DateAdd, DateConvert functions
	DateDiff, DatePart functions
	DateSerial, DateValMask, DateValue functions
	FileDateTime function
	IsDate, TimeSerial, TimeValue functions
Error Handling	On Error GoTo statement
	On Error Resume Next statement
	Err Object statement
	Reject function
File/Directory Management	FileAppend, FileCopy functions
	FileDateTime, FileDelete functions
	FileExists, FileLen, FileList functions
	FileRead, FileReadLine, FileRename functions
	FileWrite, IsFile functions
	ChangeDirectory, GetDirectory functions
	IsDirectory, MakeDirectory functions
	RemoveDirectory function
Input/Output	InputBox function
Input/Output	LogMessage function
Math	Abs, Exp, Fix, Int functions
	Log10, Rnd, Round functions
	Sgn, Val, ValMask functions
Modules	Dim statement
	Sub function
	ByVal (ByRef)
Operators	+, -, *, /, ^, Mod operators
	Integer Division () operators
	Negation (-) operator
	String concatenation (&) operator
	=, <>, <, >, <=, >=, == operators
	Not, And, Or operators
Options	Option Explicit, Option Implicit statements
Regular Expressions	GSub, Sub functions
	~ operator, !~ operator
	Like operator
Strings	Asc, Chr, InStr functions
	Len, LCase, UCase functions
	Left, Mid, Right functions
	Space(number) function
	StrComp function
	String(number, character) function
	Trim, LTrim, RTrim functions
Variables	Dim, Set, Static statements
	Private, Dim, ReDim statements
	User-defined functions
	Option Explicit statement
Variants	IsArray, IsDate functions
	IsNull function
	IsNumeric function