static Integer |
Functions.asc(String s) |
static double |
Functions.atn(double v) |
static boolean |
Functions.cbool(BigDecimal value) |
static boolean |
Functions.cbool(Boolean value) |
static boolean |
Functions.cbool(String value) |
static BigDecimal |
Functions.ccur(BigDecimal value) |
static Timestamp |
Functions.cdate(String dt) |
static Double |
Functions.cdbl(Double value) |
static Double |
Functions.cdec(Double value) |
static Short |
Functions.cint(boolean value) |
static Short |
Functions.cint(Double value) |
static Integer |
Functions.clng(Double value) |
static Integer |
Functions.clng(Integer value) |
static Integer |
Functions.clng(String value) |
static Integer |
Functions.clong(boolean value) |
static Integer |
Functions.clong(Double value) |
static Integer |
Functions.clong(Integer value) |
static Boolean |
Functions.contains(Object obj1,
Object obj2) |
static double |
Functions.csign(double value) |
static String |
Functions.cstr(Boolean value) |
static String |
Functions.cstr(double value) |
static String |
Functions.cstr(int value) |
static String |
Functions.cstr(String value) |
static String |
Functions.cstr(Timestamp value) |
static String |
Functions.cvar(Double value) |
static Timestamp |
Functions.date() |
static Date |
Functions.dateAdd(String intv,
int vl,
Date dt) |
static Timestamp |
Functions.dateAdd(String intv,
int vl,
String dt) |
static Timestamp |
Functions.dateAdd(String intv,
int vl,
Timestamp dt) |
static Integer |
Functions.dateDiff(String intv,
String dt1,
String dt2) |
static Integer |
Functions.dateDiff(String intv,
String dt1,
Timestamp dt2) |
static Integer |
Functions.dateDiff(String intv,
Timestamp dt1,
String dt2) |
static Integer |
Functions.dateDiff(String intv,
Timestamp dt1,
Timestamp dt2) |
static Integer |
Functions.datePart(String intv,
String dt) |
static Integer |
Functions.datePart(String intv,
String dt,
Integer firstDayOfWeek) |
static Integer |
Functions.datePart(String intv,
String dt,
Integer firstDayOfWeek,
Integer firstWeekOfYear) |
static Integer |
Functions.datePart(String intv,
Timestamp dt) |
static Integer |
Functions.datePart(String intv,
Timestamp dt,
Integer firstDayOfWeek) |
static Integer |
Functions.datePart(String intv,
Timestamp dt,
Integer firstDayOfWeek,
Integer firstWeekOfYear) |
static Timestamp |
Functions.dateSerial(int year,
int month,
int day) |
static Timestamp |
Functions.dateValue(String dt) |
static Timestamp |
Functions.dateValue(Timestamp dt) |
static double |
Functions.ddb(double cost,
double salvage,
double life,
double period) |
static double |
Functions.ddb(double cost,
double salvage,
double life,
double period,
double factor) |
static Boolean |
Functions.equals(Object obj1,
Object obj2) |
static Boolean |
Functions.equalsIgnoreOrder(Object obj1,
Object obj2) |
static double |
Functions.fix(double d) |
static String |
Functions.format(double d,
String par) |
static String |
Functions.format(String s,
String par) |
static String |
Functions.format(Timestamp t,
String par) |
static Boolean |
Functions.formulaToBoolean(Boolean res,
String datatype) |
static Boolean |
Functions.formulaToBoolean(Double res,
String datatype) |
static Boolean |
Functions.formulaToBoolean(String res,
String datatype) |
static Boolean |
Functions.formulaToBoolean(Timestamp res,
String datatype) |
static Timestamp |
Functions.formulaToDate(Boolean res,
String datatype) |
static Timestamp |
Functions.formulaToDate(Double res,
String datatype) |
static Timestamp |
Functions.formulaToDate(String res,
String datatype) |
static Timestamp |
Functions.formulaToDate(Timestamp res,
String datatype) |
static Double |
Functions.formulaToNumeric(Boolean res,
String datatype) |
static Double |
Functions.formulaToNumeric(Double res,
String datatype) |
static Double |
Functions.formulaToNumeric(String res,
String datatype) |
static Double |
Functions.formulaToNumeric(Timestamp res,
String datatype) |
static String |
Functions.formulaToText(Boolean res,
String datatype) |
static String |
Functions.formulaToText(Double res,
String datatype) |
static String |
Functions.formulaToText(String res,
String datatype) |
static String |
Functions.formulaToText(Timestamp res,
String datatype) |
static double |
Functions.fv(double rate,
int periods,
double payment) |
static double |
Functions.fv(double rate,
int periods,
double payment,
double pv) |
static double |
Functions.fv(double rate,
int periods,
double payment,
double pv,
double type) |
static Boolean |
Functions.iif(Boolean b,
Boolean o,
Boolean o1) |
static Double |
Functions.iif(Boolean b,
Double o,
Double o1) |
static Integer |
Functions.iif(Boolean b,
Integer o,
Integer o1) |
static String |
Functions.iif(Boolean b,
String o,
String o1) |
static Timestamp |
Functions.iif(Boolean b,
Timestamp o,
Timestamp o1) |
static Integer |
Functions.instr(Integer start,
String text,
String search) |
static Integer |
Functions.instr(Integer start,
String text,
String search,
Integer compare) |
static Integer |
Functions.instr(String text,
String search) |
static Integer |
Functions.instr(String text,
String search,
Integer compare) |
static Integer |
Functions.instrrev(String text,
String search) |
static Integer |
Functions.instrrev(String text,
String search,
Integer start) |
static Integer |
Functions.instrrev(String text,
String search,
Integer start,
Integer compare) |
static double |
Functions.ipmt(double rate,
double per,
double nper,
double pv) |
static double |
Functions.ipmt(double rate,
double per,
double nper,
double pv,
double fv) |
static double |
Functions.ipmt(double rate,
double per,
double nper,
double pv,
double fv,
double type) |
static boolean |
Functions.isDate(String dt) |
static boolean |
Functions.isDate(Timestamp dt) |
static boolean |
Functions.isNull(Double o) |
static boolean |
Functions.isNull(String o) |
static boolean |
Functions.isNull(Timestamp o) |
static boolean |
Functions.isNumeric(BigDecimal b) |
static boolean |
Functions.isNumeric(String s) |
static String |
Functions.left(String input,
int i) |
static String |
Functions.leftS(String input,
int i) |
static Integer |
Functions.len(String o) |
static String |
Functions.mid(String value,
int start) |
static String |
Functions.mid(String value,
int start,
int length) |
static Short |
Functions.mint(boolean value) |
static Integer |
Functions.mint(Double value) |
static String |
Functions.monthName(int i) |
static String |
Functions.monthName(int i,
boolean abbr) |
static Timestamp |
Functions.now() |
static double |
Functions.nper(double rate,
double pmt,
double pv) |
static double |
Functions.nper(double rate,
double pmt,
double pv,
double fv) |
static double |
Functions.nper(double rate,
double pmt,
double pv,
double fv,
double type) |
static BigDecimal |
Functions.nz(BigDecimal value) |
static BigDecimal |
Functions.nz(BigDecimal value,
BigDecimal outher) |
static Double |
Functions.nz(Double value) |
static Double |
Functions.nz(Double value,
Double outher) |
static Integer |
Functions.nz(Integer value) |
static Integer |
Functions.nz(Integer value,
Integer outher) |
static String |
Functions.nz(String value) |
static String |
Functions.nz(String value,
String outher) |
static String |
Functions.orderJet(String s) |
static String |
Functions.partition(Double number,
double start,
double stop,
double interval) |
static double |
Functions.pmt(double rate,
double periods,
double pv) |
static double |
Functions.pmt(double rate,
double periods,
double pv,
double fv) |
static double |
Functions.pmt(double rate,
double periods,
double pv,
double fv,
double type) |
static double |
Functions.ppmt(double rate,
int per,
int nper,
double pv) |
static double |
Functions.ppmt(double rate,
int per,
int nper,
double pv,
double fv) |
static double |
Functions.ppmt(double rate,
int per,
int nper,
double pv,
double fv,
double type) |
static double |
Functions.pv(double rate,
double nper,
double pmt) |
static double |
Functions.pv(double rate,
double nper,
double pmt,
double fv) |
static double |
Functions.pv(double rate,
double nper,
double pmt,
double fv,
double type) |
static double |
Functions.rate(double nper,
double pmt,
double pv) |
static double |
Functions.rate(double nper,
double pmt,
double pv,
double fv) |
static double |
Functions.rate(double nper,
double pmt,
double pv,
double fv,
double type) |
static double |
Functions.rate(double nper,
double pmt,
double pv,
double fv,
double type,
double guess) |
static String |
Functions.right(String input,
int i) |
static String |
Functions.rightS(String input,
int i) |
static Double |
Functions.rnd() |
static Double |
Functions.rnd(Double d) |
static double |
Functions.round(double d,
double p) |
static short |
Functions.sign(double n) |
static double |
Functions.sln(double cost,
double salvage,
double life) |
static String |
Functions.space(Integer nr) |
static double |
Functions.sqr(double v) |
static String |
Functions.str(double d) |
static Integer |
Functions.strComp(String value1,
String value2) |
static Integer |
Functions.strComp(String value1,
String value2,
Integer type) |
static String |
Functions.strConv(String value,
int ul) |
static String |
Functions.string(Integer nr,
String str) |
static String |
Functions.strReverse(String value) |
static double |
Functions.syd(double cost,
double salvage,
double life,
double per) |
static Timestamp |
Functions.time() |
static Timestamp |
Functions.timeserial(Integer h,
Integer m,
Integer s) |
static Timestamp |
Functions.timestamp0(String dt) |
static Double |
Functions.val(BigDecimal val1) |
static Double |
Functions.val(String val1) |
static Integer |
Functions.weekDay(Timestamp dt) |
static Integer |
Functions.weekDay(Timestamp dt,
Integer firstDayOfWeek) |
static String |
Functions.weekDayName(int i) |
static String |
Functions.weekDayName(int i,
boolean abbr) |
static String |
Functions.weekDayName(int i,
boolean abbr,
int s) |