HelpPages

Home | Developer | Introduction | Sintaxis y Funciones

Sintaxis y Funciones

                                 Expressions and Functions
                                 =========================

ALPHA                         identify by $. Sample: a$, var$, $value, b$='hello'
NUMERIC                       identify by #. Sample: a#, num#, x#=25.37+14.56
SMALL                         Sample: a, b, integer=25 (range -376 to 376)

FN#FLEN(filename$)            Return length of file named
FN#SLEN(var$)                 Return length of var$
FN#PARM(var$)                 Number of comma separated parameters of var$
FN#VALN(var$)                 Return the value of an string array
FN#ACUM()                     In develop. Do not use it
_#                            Not available by now
CHK#(cnd;OKexp;FAILexp)                                If condition is TRUE, returns the value of
                                                                 OK expression, else of FAIL exp
FILEFIND(key$0)                                FileSearch. Return 0=OK, 1=Fail, 2=EoFile
FILEREL(main;rel;crit)                                Relational Search 0=OK, 1=Fail, 2=EoFile
FILELOCATE(cmd0)                                File Move. cmd$                'NEXT' step forward
                                                                                                 'PREVIOUS' step back
                                                                                                 'TOP'                goto begin
                                                                                                 'BOTTOM' goto end
FILESEL(file0)                                Select files to use on non SQL Databases
FN$CHNG(main$;mtch$;new$)                Replace ocurrences of mtch$ in main$ for new$
FN$CHRS(chrvalue)                                                The chr () function
FN$FECC(date$;mode)                                Date formats: mode 0=Internal, 1=Ext, 2=Width
FN$FLDS(screendef)                                Returns the value of a Screen Field
FN$MASK(mask$;v/v#/v$)                                Return then mask formated
FN$MIDS(var$;offset;size)                                Returns the substring offset, size
FN$PARM(var$;n)                                                Return the n comma separated param of var$
FN$SCHG(main$;mtch$;new$)                Replace ocurrences of mtch$ in main$ for new$
FN$TRIM(var$;md$)                                Retrieve trim blanck chars. md$:
                                                                                 'LEFTTRIM' left retrive
                                                                                 'RIGHTTRIM' right retrieve
                                                                                 'BOTHTRIM' left and right trim
FN$TXTN(value/value#)                                Returns the string of value/value#
CHK$(cond;OKexp;FAILexp)                                Same than CHK# but with alpha results
SORT$                                                                Not usable by now
EXEC$(prgfile$)                                                Execute prgfile
READ$(file$[;off0])                                Return to a string the content of file$
WRITE$(file$;offset;var$)                                Write var$ to file at offset
MACRO$(macro$)                                                Return the macrosubstitution of macro (0)
ENVRON$                                                Return an environmment variable
_$                                                                Return the last Acumulator
KEY$([file[;ndx0]])                                Return key from buff (mode=0)/oldbuf(mode=1)
TIME$(timeexp;mode)                                Return formats for time
SQLCHILD(cmdlist)                                Preserve current SQL datas at exec cmdlist