Document

Click here to download Manual(pdf)

Function list

Character Function

ASC	Chr	ChrS	CompareStr
CompareText	Concat	Copy	Delete
Insert	LeftStr	Length	Lower
LTrim	MidStr	Pos	RightStr
RPos	RTrim	SParam	SameText
SubS	Trim	UpLower	Upper
WideCompareStr	WideCompareText	WideSameStr	WideSameText
WideLowerCase	WideUpperCase

Number Function

Abs	ArcCos	ArcCosh	ArcCot
ArcCoth	ArcCsc	ArcCsch	ArcSec
ArcSech	ArcSins	ArcSinH	ArcTan
ArcTan2s	ArcTanH	Ceil	Cos
Cosecant	Cosh	Cot	Cotan
CotH	Csc	CscH	CompareValue
Div	Exp	Floor	Frac
Hypot	InRange	Int	Ln
Log10	Log2	LogN	Max
Min	Mod	Neg	Order
Pi	Random	Round	Trunc
Sec	Secant	SecH	Sin
Sinh	Sqr	Sqrt	Tan
Tanh

Date Time Function

CompareDate	CompareDateTime	CompareTime	CurrentYear
Date	DateOf	DateTimeToStr	DateToStr
DayOf	DayOfTheMonth	DayOfTheWeek	DayOfTheYear
DaysBetween	DaysInAMonth	DaysInAYear	DaysInMonth
DaysInYear	DaySpan	EncodeDate	EncodeDateDay
EncodeDateMonthWeek	EncodeDateTime	EncodeDateWeek	EncodeDayOfWeekInMonth
EncodeTime	EndOfADay	EndOfAMonth	EndOfAWeek
EndOfAYear	EndOfTheDay	EndOfTheMonth	EndOfTheWeek
EndOfTheYear	FormatDateTime	HourOf	HourOfTheDay
HourOfTheMonth	HourOfTheWeek	HourOfTheYear	HoursBetween
HourSpan	IncDay	IncHour	IncMilliSecond
IncMinute	IncMonth	IncSecond	IncWeek
IncYear	IsInLeapYear	IsPM	IsSameDay
IsToday	Now	MilliSecondOf	MilliSecondOfTheDay
MilliSecondOfTheHour	MilliSecondOfTheMinute	MilliSecondOfTheMonth	MilliSecondOfTheSecond
MilliSecondOfTheWeek	MilliSecondOfTheYear	MilliSecondsBetween	MilliSecondSpan
MinuteOf	MinuteOfTheDay	MinuteOfTheHour	MinuteOfTheMonth
MinuteOfTheWeek	MinuteOfTheYear	MinutesBetween	MinuteSpan
MonthOf	MonthOfTheYear	MonthsBetween	MonthSpan
RecodeDate	RecodeDateTime	RecodeDay	RecodeHour
RecodeMilliSecond	RecodeMinute	RecodeMonth	RecodeSecond
RecodeTime	RecodeYear	SameDate	SameDateTime
SameTime	SecondOf	SecondOfTheDay	SecondOfTheHour
SecondOfTheMinute	SecondOfTheMonth	SecondOfTheWeek	SecondOfTheYear
SecondsBetween	SecondSpan	StartOfADay	StartOfAMonth
StartOfAWeek	StartOfAYear	StartOfTheDay	StartOfTheMonth
StartOfTheWeek	StartOfTheYear	StrToDate	StrToDateTime
StrToTime	Time	TimeOf	TimeToStr
Today	Tomorrow	WeekOf	WeekOfTheMonth
WeekOfTheYear	WeeksBetween	WeekSpan	WeeksInYear
WithinPastDays	WithinPastHours	WithinPastMilliSeconds	WithinPastMinutes
WithinPastMonths	WithinPastSeconds	WithinPastWeeks	WithinPastYears
YearOf	YearsBetween	YearSpan	Yesterday

Database Function

RecordNum	DBEof	DBBof	FieldName
FieldNo	FieldLen	FieldDec	RecordCount
FieldValue	FieldCount	FieldPriorValue	FieldNextValue
ExecOraQuery	ExecOraProc	ExecMSSQLQuery	ExecMSSQLProc
ExecODBCQuery	ExecODBCProc

Miscellaneous Function

Beep	Case	Decode	Iif
Like	LikeAny	Not	Void
Null	WinExec	FileName	FilePath
MoveFile	CopyFile	IsNull

Conversion Function

FloatToStr	FormatFloat	IntToHex	IntToStr
StrToFloat	ToBool	ToChar	ToInt
ToReal	ToStr	ToTime