客户端函数
- 基本函数
- str(aValue)
- trim(asStr)
- isEmpty(aValue)
- iif(aValue, aValue1, aValue2)
- abs(aValue)
- isnull(aValue, aValue1)
- round(aValue, aPre)
- roundpro(aValue, aPre)
- roundUp(aValue, aPre)
- roundDown(aValue, aPre)
- right(aValue, count)
- left(aValue, count)
- pos(aValueStr, asSubStr)
- upper(aValue)
- lower(aValue)
- subStr(aValue, start, count)
- fdouble(aValue)
- fint(aValue)
- zero(aValue)
- iszero(aValue, aValue1)
- power(aValue, aPower)
- rmb(money)
- now()
- strToDate(aDate)
- formatdt(aValue,asFormat)
- dateAdd(aDate, aValue)
- monthAdd(aDate,aValue)
- yearAdd(aDate,aValue)
- dateSub(date1, date2) date2 减去 date1 ，结果为天数
- quotedStr(aValue)
- replace(asStr,asSubStr,asReplaceBy)
- replaceChar(asStr,asSubStr,asReplaceBy)
- len(asStr)
- clienttype()
- rand()
- mod(a,b)
- execScript(asScript)
- subword(asStr,asSeparator,aPos)
- monthindex(asMonth)
- monthdate(asMonth)
- 数据集函数
- object sum(exp)
- object count(exp) 非空非0 数量 count 参数可以有表达式
- avg(exp) 平均数
- paramValue(asParamCode)
- metaparam(asERI,asParamCode)
- blEntityId()
- blEntityName()
- blEntityCode()
- eri()
- recno();//记录号
- enterprise() 系统代码 roomcode
- session
- userproperty
- userName _userName'
- userCode_userCode
- userid
- hostDate
- hostTime
- userhouseid
- useremployeeid
- useremployeename
- userroomid
Created with the Personal Edition of HelpNDoc: Full-featured Documentation generator