Functions

 

Numeric, Alphabetic, date and variable type functions

Numeric functions

- classic
- truncation
- statistics
- string
- date
- operators
- arithmetic
- miscellaneous
- trigonometric
- hyperbolic
- logarithmic
- classes of variables
- tables
- sequential files
- masks

Alphanumeric functions

- sub-string extraction
- string transformation
- miscellaneous string functions
- string generation
- string display
- classes, masks

Date functions

Variable type functions

Debugger functions

Call to a function

 


Numeric functions     

·        classic

 

abs()

absolute value

 

mod()

remainder following integer division

 

rnd()

random number

 

sgn()

sign

 

sqr()

square root

 

·        truncation

 

ar2()

rounding to 2 decimal numbers

 

arr()

rounding to the nearest number

 

fix()

truncation

 

int()

integer part

 

·        statistics

 

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

 

·        string

 

ASCII()

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

 

·        date

 

day

day

 

dayn

day number in the week

 

month

number of the month

 

nday

number of days since 1/1/1600

 

week

week number associated with a date

 

year

year

 

·        operators

 

and

logical and

 

not

logical negation

 

or

logical or

 

xor

logical exclusive or

 

+

addition

 

-

subtraction

 

*

multiplication

 

/

division

 

^

to the power

 

·        arithmetic

 

anp()

number of arrangements

 

cnp()

number of combinations

 

fac()

factorial

  

·        miscellaneous

 

adxpid

Adonix process number

 

adxtcp

service number used for the connections

 

adxuid

user identification

 

dim()

dimensions of a variable

 

errl

line number in a process

 

errn

error number

 

freemem

available memory

 

nbruser

number of users of the application

 

time

local time in seconds

 

type()

type of a variable

 

varmode

determines if the field can be entered or displayed

 

·        trigonometric

 

acos()

arc-cosine

 

asin()

arc-sine

 

atan()

arc-tangent

 

atan2()

arc-tangent with respect of the arguments

 

cos()

cosine

 

sin()

sine

 

tan()

tangent

 

pi

returns an approximate value of the constant for the perimeter of a circle with respect to its diameter.

 

·        hyperbolic

 

ach()

arg-cosine

 

ash()

arg-sine

 

ath()

arg-tangent

 

ch()

hyperbolic cosine

 

sh()

hyperbolic sine

 

th()

hyperbolic tangent

 

·        logarithmic

 

exp()

exponential

 

ln()

Naperian logarithm

 

log()

decimal logarithm

 

·        variable classes

 

clalev()

class used or not

 

clanbs()

number of defined symbols

 

clasiz()

number of allocated symbols

 

·        tables

 

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

 

·        sequential files

 

adxseek

position of read and write pointers in sequential files

 

·        masks

 

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

Alphanumeric functions

·        extraction of sub-strings

 

left$()

from the left

 

mid$()

from a position

 

right$()

from the right

 

seg$()

between two positions

 

·        string transformation

 

ctrans()

in characters codes on 7 bits

 

tolower()

uppercase into lowercase

 

toupper()

lowercase into uppercase

 

vireblc()

deletion of spaces

 

·        miscellaneous string functions

 

adxmac

machines where the reference applications are installed

 

adxpam

function parameter for the selected menu

 

adxpno()

stack of OBJect names

 

cop$

Adonix copyright message

 

day$()

name of the day

 

dir$

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

 

time$

local time

 

trtcou

current process

 

ver$()

version and license number

 

·        string generation

 

chr$()

ASCII character

 

graph$()

semi-graphical string of graphs

 

space$()

string filled with spaces

 

string$()

string repeating a sub-string or ASCII code

 

·        string display

 

errm

second part of an error message

 

errmes$()

Error messages

 

errp

process in which the error has occurred

 

·        classes, masks

 

clanam()

name of the class

 

clavar()

name of the variables in a class

 

maskabr()

abbreviation of a mask

 

maskcou

name of the current mask

 

masknam()

name of the mask

  Date functions

 

addmonth()

add a number for the month to a date

 

aweek()

start date for a week

 

date$

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

  Variable type functions

 

evalue()

evaluation of a formula

 

max()

maximum in a list

 

min()

minimum in a list

 

sigma()

sum or concatenation

 

sum()

sum or concatenation

Debugger functions

 

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 

 

Func

Call to a function