Functions |
|
|
|
abs() |
absolute value |
|
|
mod() |
remainder following integer division |
|
|
rnd() |
random number |
|
|
sgn() |
sign |
|
|
sqr() |
square root |
|
|
ar2() |
rounding to 2 decimal numbers |
|
|
arr() |
rounding to the nearest number |
|
|
fix() |
truncation |
|
|
int() |
integer part |
|
|
avg() |
average |
|
|
find() |
search in a list |
|
|
max() |
maximum in a list |
|
|
min() |
minimum in a list |
|
|
prd() |
product |
|
|
sigma() |
sum or concatenation |
|
|
sum() |
sum or concatenation |
|
|
uni() |
search for a duplicated value |
|
|
var() |
variance |
|
|
ASCII code |
|
|
|
len() |
length of a string |
|
|
parse() |
analysis of syntax in an expression |
|
|
pat() |
conformity of a string to a pattern |
|
|
val() |
decimal representation of a string |
|
|
day |
|
|
|
day number in the week |
|
|
|
number of the month |
|
|
|
number of days since 1/1/1600 |
|
|
|
week number associated with a date |
|
|
|
year |
|
|
logical and |
|
|
|
logical negation |
|
|
|
logical or |
|
|
|
logical exclusive or |
|
|
|
+ |
addition |
|
|
- |
subtraction |
|
|
* |
multiplication |
|
|
/ |
division |
|
|
^ |
to the power |
|
|
anp() |
number of arrangements |
|
|
cnp() |
number of combinations |
|
|
fac() |
factorial |
|
|
Adonix process number |
|
|
|
service number used for the connections |
|
|
|
user identification |
|
|
|
dim() |
dimensions of a variable |
|
|
line number in a process |
|
|
|
error number |
|
|
|
available memory |
|
|
|
number of users of the application |
|
|
|
local time in seconds |
|
|
|
type() |
type of a variable |
|
|
determines if the field can be entered or displayed |
|
|
acos() |
arc-cosine |
|
|
asin() |
arc-sine |
|
|
atan() |
arc-tangent |
|
|
atan2() |
arc-tangent with respect of the arguments |
|
|
cos() |
cosine |
|
|
sin() |
sine |
|
|
tan() |
tangent |
|
|
returns an approximate value of the constant for the perimeter of a circle with respect to its diameter. |
|
|
ach() |
arg-cosine |
|
|
ash() |
arg-sine |
|
|
ath() |
arg-tangent |
|
|
ch() |
hyperbolic cosine |
|
|
sh() |
hyperbolic sine |
|
|
th() |
hyperbolic tangent |
|
|
exp() |
exponential |
|
|
ln() |
Naperian logarithm |
|
|
log() |
decimal logarithm |
|
|
clalev() |
class used or not |
|
|
clanbs() |
number of defined symbols |
|
|
clasiz() |
number of allocated symbols |
|
|
filinfo() |
characteristics of a file |
|
|
filelev() |
location level |
|
|
nbrecord() |
number of records |
|
|
rowcount() |
number of records of for all or part of a table or a link |
|
|
uniqid() |
following unique integers |
|
|
position of read and write pointers in sequential files |
|
|
inpmode() |
mode used in entry of a field |
|
|
varinit() |
variable for mask initialized or not |
|
|
masklev() |
location level |
|
|
masknbf() |
number of fields |
|
|
maskrk() |
rank of variables |
|
|
masksiz() |
size in bytes |
|
|
left$() |
from the left |
|
|
mid$() |
from a position |
|
|
right$() |
from the right |
|
|
seg$() |
between two positions |
|
|
ctrans() |
in characters codes on 7 bits |
|
|
tolower() |
uppercase into lowercase |
|
|
toupper() |
lowercase into uppercase |
|
|
vireblc() |
deletion of spaces |
|
|
machines where the reference applications are installed |
|
|
|
function parameter for the selected menu |
|
|
|
adxpno() |
stack of OBJect names |
|
|
Adonix copyright message |
|
|
|
day$() |
name of the day |
|
|
Adonix launch directory |
|
|
|
filcom() |
comment |
|
|
filpath() |
access path for a file |
|
|
format$() |
formatting of an expression |
|
|
getenv$() |
value of an environment variable |
|
|
instr() |
search for a sub-string |
|
|
mess() |
message file messages |
|
|
month$() |
name of the month |
|
|
num$() |
string containing a decimal representation |
|
|
local time |
|
|
|
current process |
|
|
|
ver$() |
version and license number |
|
|
chr$() |
ASCII character |
|
|
graph$() |
semi-graphical string of graphs |
|
|
space$() |
string filled with spaces |
|
|
string$() |
string repeating a sub-string or ASCII code |
|
|
second part of an error message |
|
|
|
errmes$() |
Error messages |
|
|
process in which the error has occurred |
|
|
clanam() |
name of the class |
|
|
clavar() |
name of the variables in a class |
|
|
maskabr() |
abbreviation of a mask |
|
|
name of the current mask |
|
|
|
masknam() |
name of the mask |
|
|
addmonth() |
add a number for the month to a date |
|
|
aweek() |
start date for a week |
|
|
current date |
|
|
|
eomonth() |
date corresponding to the last day of a month |
|
|
gdat$() |
construction of a date |
|
|
nday$() |
date corresponding to a number of days |
|
|
evalue() |
evaluation of a formula |
|
|
max() |
maximum in a list |
|
|
min() |
minimum in a list |
|
|
sigma() |
sum or concatenation |
|
|
sum() |
sum or concatenation |
|
|
adxcio |
number of open sequential files |
|
|
adxioa |
abbreviation of open sequential files |
|
|
adxnfs |
name of the open sequential files |
|
|
filecla |
number of classes in open tables |
|
|
filetyp |
types of tables |
|
|
maskcla |
number of open masks |
|
|
progcan |
process name |
|
|
progldd |
process identifier loaded in memory |
|
|
progsiz |
size of the process |
|
|
progusd |
identifier for the process currently being used |
|
|
Call to a function |