Extracts the year number associated with a specified date value.
$year(date)| date | a data, or an expression that evaluates to a date, in the form YYYYMMDD |
Character string.
This function extracts day information from standard date values. Date is often the system variable $Date.
$year(19981225)
Evaluates to “1998”.
$year($date + 7)
Evaluates to “1999” when $Date is 19991225.
Tests if a character string is a valid object name.
$iszimname(string)| string | a character string or an expression that evaluates to a character string |
1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False).
This function tests if a particular character string is valid zim object name.
$iszimname(189)
Evaluates to $False.
$iszimname("Fields")Evaluates to $True.
Controls the overall width of pages output by the LIST command.
SET PAGEWIDTH num
| num | Num specifies, in characters, the width of an output page. Num can be an integer constant (e.g., 15, 200). a variable, form field, menu item, or parameter that evaluates to an integer. |
The PAGEWIDTH option is set to 80 characters by default.
If the data generated by LIST or SELECT exceeds the current PAGEWIDTH, the software assumes that the output device wraps data onto subsequent lines.
set output printer
set pause on
set pagesize 40
set pagewidth 120
list all Employees sorted by Department
Here, the SET PAGEWIDTH command (together with SET PAGESIZE) sets LIST output for printing in the landscape orientation.
See Also
Determines the day-of-the-week number associated with a specified date value.
$weekday(date)| date | a date, or an expression that evaluates to a date, in the form YYYYMMDD |
Character string.
This function extracts day information from standard date values. Date is often the system variable $Date.
$weekday(19981225)
Evaluates to “7”.
$weekday($date+7)
Evaluates to “7” when $Date is 19981225.
Tests if an expression produces a valid number after its evaluation.
$isnumber(expression)| string | a character string or an expression that evaluates to a character string |
1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False).
This function tests if a particular character string is a valid number.
$isnumber(2+3)
Evaluates to $True.
$isnumber($trim(LastName))
Evaluates to $False.
Converts a character into its ordinal number value.
$toord(char)| char | a character string, or any expression that evaluates to a character string |
Number.
Each of the decimal numbers from 0 to 255 represents a character output by your workstation. $Toord converts the given character to the corresponding decimal number.
If char contains more than one character, only the first character is converted.
The number produced by the $toord function can be converted back to a character by the $tochr function.
$toord(" ")Evaluates to 32 (on ASCII machines).
$toord(tochr(anynumber ))
Evaluates to any number.
Controls the overall length of pages output by the LIST command.
SET PAGESIZE num
| num | Num specifies, in lines, the height of an output page. Num can be: an integer constant (e.g., 15, 200); a variable, form field, menu item, or parameter that evaluates to an integer. |
The PAGESIZE option is set to 24 lines by default.
The PAGESIZE option should be adjusted to suit the current output device (e.g., 66 lines for a printer, 24 lines for a terminal screen).
set output printer
set pause on
set pagesize 40
set pagewidth 120
list all Employees sorted by Department
Here, the SET PAGESIZE command (together with SET PAGEWIDTH) sets LIST output for printing in the landscape orientation.
See Also
Tests if the letters in a character string are uppercase.
$isupper(string)| string | a character string or an expression that evaluates to a character string |
1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False).
This function tests if a particular character string is uppercase, i.e., contains no lowercase letters.
$isupper("aBC")Evaluates to $False.
$isupper(43)
Evaluates to $True.
Tests if a character string contains only letters.
$isalphabetic(string)| string | a character string or an expression that evaluates to a character string |
1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False).
This function tests if a particular character string is alphabetic.
$isalphabetic("abc")Evaluates to $True.
$isalphabetic("abc1")Evaluates to $False.
Tests if the letters in a character string are lowercase.
$islower(string)| string | a character string or an expression that evaluates to a character string |
1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False).
This function tests if a particular character string is lower case, i.e., contains no uppercase letters.
$islower("Abc")Evaluates to $False.
$islower(34)
Evaluates to $True.
Portuguese 
English