Abs(X: Double): Double |
Returns the absolute value of the argument, X. |
ArcTan(X: Double): Double |
Returns the arctangent of a given Double X. |
Cos(X: Double): Double |
Returns the cosine of the angle X, in radians. |
Exp(X: Double): Double |
Returns the value of e raised to the power of X, where e is the base of the
natural logarithms. |
Frac(X: Double): Double |
Returns the fractional part of the argument X. |
Int(X: Double): Double |
Returns the integer part of X, that is, X rounded toward zero. |
Log(X: Double): Double |
Returns the natural log of a real expression. |
Round(X: Double): Double |
Returns the value of X rounded to the nearest whole Double. |
Sin(X: Double): Double |
Returns the sine of the angle in radians. |
Sqrt(X: Double): Double |
Returns the square root of X. |
Arguments in brackets are optional.
Asc(c: Character): Double |
Returns the ordinal value of a character. |
Chr(n: Double): Character |
Returns the character for a specified ASCII value. |
Exchange(Source, From, To: String): String |
Replaces all occurrences of From in Source by To and
returns the modified string. |
FillStr(Source, Filler: String; Len: Double): String |
Fills the Source with the Filler up to the given
Length and returns the result. |
LeftStr(Source: String; Len: Double): String |
Return the left substring of source with given length. |
Length(Source: String) |
Return the count of characters in Source. |
Lower(Source: String): String |
Returns the string in lowercase. |
LTrim(Source: String): String |
Returns Source without any leading white-space. |
MemoStr(Memo: MemoField): String |
Returns the first 255 characters of the content of the memo field in the
current record. |
NTimes(Source: String; Count: Double): String |
Returns a string that repeats Source Count times. |
Pos(SubStr, Source: String): String |
Returns the position of SubStr in Source or 0, if
SubStr is not contained in Str. |
RightStr(Source: String; Len: Double): String |
Returns the Len last characters of Source. |
RTrim(Source: String): String |
Returns Source without any trailing white-spaces. |
Scan(SubStr, Source: String): Double |
Returns the Double of occurences of SubStr in Str. |
Str(Num: Double[; Width, Precision: Double]): String |
Returns the alphanumeric representation of Num with given
Width and Precision. Width=1 means as needed. |
All numeric operators can equally be used for date and time values. All date
values are treated like the Double of days since 1/1/0000. Time values stand
for the Double of minutes since midnight. This way Date2 - Date1 results
in the Double of days from Date1 to Date2. Time2 - Time1
returns the Double of minutes from Time1 to Time2. Beyond the
numeric operators and functions there are also special date and time functions:
DateStr(Date: Double): String |
Returns the string representation of a date. |
Day(Date: Double): Double |
Extracts the day out of a date. |
DayOfWeek(Date: Double): String |
Returns the week-day of the date as string. |
Month(Date: Double): Double |
Extracts the month out of a date. |
Now: Double |
Returns the current time. |
TimeStr(Time: Double): String |
Returns the string representation of a time value. |
Today: Double |
Returns the current date. |
Val(Str: String): Double |
Returns the numeric value from a date/time string. |
Week(Date: Double): Double |
Returns the Double of the week in the current year. |
Year(Date: Double): Double |
Extracts the year out of a date. |