: Class vb

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: INNER | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

jasp.vbs
Class vb

java.lang.Object
  |
  +--jasp.vbs.vb

public class vb
extends java.lang.Object

This class implements VBScript Functions.

Constructor Summary

vb()


Method Summary

static short Abs(boolean number)
          Returns the absolute value of a boolean number.

static double Abs(double number)
          Returns the absolute value of a double number.

static int Abs(int number)
          Returns the absolute value of an integer number.

static double Abs(java.lang.String number)
          Returns the absolute value of a string.

static variant Abs(variant number)
          Returns the absolute value of a variant.

static vbcurrency Abs(vbcurrency number)
          Returns the absolute value of a vbcurrency.

static vbdate Abs(vbdate number)
          Returns the absolute value of a vbdate.

static variant Array()
          Returns a Variant containing an array.

static variant Array(pVector vv)
          Returns a Variant containing an array.

static short Asc(boolean string)
          Returns the ANSI character code corresponding to the first letter in a boolean string.

static short Asc(double string)
          Returns the ANSI character code corresponding to the first letter in a numeric string.

static short Asc(float string)
          Returns the ANSI character code corresponding to the first letter in a numeric string.

static short Asc(int string)
          Returns the ANSI character code corresponding to the first letter in a numeric string.

static short Asc(long string)
          Returns the ANSI character code corresponding to the first letter in a numeric string.

static short Asc(java.lang.String string)
          Returns the ANSI character code corresponding to the first letter in a string.

static short AscB(boolean string)
          Do not support AscB Function.

static short AscB(double string)
          Do not support AscB Function.

static short AscB(java.lang.String string)
          Do not support AscB Function.

static short AscW(boolean string)
          Do not support AscW Function.

static short AscW(double string)
          Do not support AscW Function.

static short AscW(java.lang.String string)
          Do not support AscW Function.

static double Atn(boolean number)
          Returns the arctangent of a boolean value.

static double Atn(double number)
          Returns the arctangent of a number.

static double Atn(java.lang.String number)
          Returns the arctangent of a numeric string.

static boolean CBool(boolean expression)
          Returns an expression that has been converted to a Variant of subtype boolean.

static boolean CBool(double expression)
          Returns an expression that has been converted to a Variant of subtype boolean.

static boolean CBool(java.lang.String expression)
          Returns an expression that has been converted to a Variant of subtype boolean.

static boolean CBool(variant expression)
          Returns an expression that has been converted to a Variant of subtype boolean.

static boolean CBool(vbcurrency expression)
          Returns an expression that has been converted to a Variant of subtype boolean.

static boolean CBool(vbdate expression)
          Returns an expression that has been converted to a Variant of subtype boolean.

static short CByte(boolean expression)
          Returns an expression that has been converted to a Variant of subtype Byte.

static short CByte(double expression)
          Returns an expression that has been converted to a Variant of subtype Byte.

static short CByte(java.lang.String expression)
          Returns an expression that has been converted to a Variant of subtype Byte.

static short CByte(variant expression)
          Returns an expression that has been converted to a Variant of subtype Byte.

static short CByte(vbcurrency expression)
          Returns an expression that has been converted to a Variant of subtype Byte.

static short CByte(vbdate expression)
          Returns an expression that has been converted to a Variant of subtype Byte.

static vbcurrency CCur(boolean expression)
          Returns an expression that has been converted to a Variant of subtype Currency.

static vbcurrency CCur(double expression)
          Returns an expression that has been converted to a Variant of subtype Currency.

static vbcurrency CCur(java.lang.String expression)
          Returns an expression that has been converted to a Variant of subtype Currency.

static vbcurrency CCur(variant expression)
          Returns an expression that has been converted to a Variant of subtype Currency.

static vbcurrency CCur(vbcurrency expression)
          Returns an expression that has been converted to a Variant of subtype Currency.

static vbcurrency CCur(vbdate expression)
          Returns an expression that has been converted to a Variant of subtype Currency.

static vbdate CDate(boolean date)
          Returns an expression that has been converted to a Variant of subtype Date.

static vbdate CDate(double date)
          Returns an expression that has been converted to a Variant of subtype Date.

static vbdate CDate(java.lang.String date)
          Returns an expression that has been converted to a Variant of subtype Date.

static vbdate CDate(variant date)
          Returns an expression that has been converted to a Variant of subtype Date.

static vbdate CDate(vbcurrency date)
          Returns an expression that has been converted to a Variant of subtype Date.

static vbdate CDate(vbdate date)
          Returns an expression that has been converted to a Variant of subtype Date.

static double CDbl(boolean expression)
          Returns an expression that has been converted to a Variant of subtype Double.

static double CDbl(double expression)
          Returns an expression that has been converted to a Variant of subtype Double.

static double CDbl(java.lang.Object expression)
          Returns an expression that has been converted to a Variant of subtype Double.

static double CDbl(java.lang.String expression)
          Returns an expression that has been converted to a Variant of subtype Double.

static double CDbl(variant expression)
          Returns an expression that has been converted to a Variant of subtype Double.

static double CDbl(vbcurrency expression)
          Returns an expression that has been converted to a Variant of subtype Double.

static double CDbl(vbdate expression)
          Returns an expression that has been converted to a Variant of subtype Double.

static java.lang.String Chr(boolean charcode)
          Returns the character associated with the specified ANSI character code.

static java.lang.String Chr(double charcode)
          Returns the character associated with the specified ANSI character code.

static java.lang.String Chr(java.lang.String charcode)
          Returns the character associated with the specified ANSI character code.

static short CInt(boolean expression)
          Returns an expression that has been converted to a Variant of subtype Integer.

static short CInt(double expression)
          Returns an expression that has been converted to a Variant of subtype Integer.

static short CInt(java.lang.String expression)
          Returns an expression that has been converted to a Variant of subtype Integer.

static short CInt(variant expression)
          Returns an expression that has been converted to a Variant of subtype Integer.

static short CInt(vbcurrency expression)
          Returns an expression that has been converted to a Variant of subtype Integer.

static short CInt(vbdate expression)
          Returns an expression that has been converted to a Variant of subtype Integer.

static int CLng(boolean expression)
          Returns an expression that has been converted to a Variant of subtype Long.

static int CLng(double expression)
          Returns an expression that has been converted to a Variant of subtype Long.

static int CLng(java.lang.String expression)
          Returns an expression that has been converted to a Variant of subtype Long.

static int CLng(variant expression)
          Returns an expression that has been converted to a Variant of subtype Long.

static int CLng(vbcurrency expression)
          Returns an expression that has been converted to a Variant of subtype Long.

static int CLng(vbdate expression)
          Returns an expression that has been converted to a Variant of subtype Long.

static double Cos(boolean number)
          Returns the cosine of an angle.

static double Cos(double number)
          Returns the cosine of an angle.

static double Cos(java.lang.String number)
          Returns the cosine of an angle.

static double Cos(variant number)
          Returns the cosine of an angle.

static double Cos(vbcurrency number)
          Returns the cosine of an angle.

static double Cos(vbdate number)
          Returns the cosine of an angle.

static float CSng(boolean expression)
          Returns an expression that has been converted to a Variant of subtype Single.

static float CSng(double expression)
          Returns an expression that has been converted to a Variant of subtype Single.

static float CSng(java.lang.String expression)
          Returns an expression that has been converted to a Variant of subtype Single.

static float CSng(variant expression)
          Returns an expression that has been converted to a Variant of subtype Single.

static float CSng(vbcurrency expression)
          Returns an expression that has been converted to a Variant of subtype Single.

static float CSng(vbdate expression)
          Returns an expression that has been converted to a Variant of subtype Single.

static java.lang.String CStr(boolean expression)
          Returns an expression that has been converted to a Variant of subtype String.

static java.lang.String CStr(double expression)
          Returns an expression that has been converted to a Variant of subtype String.

static java.lang.String CStr(int expression)
          Returns an expression that has been converted to a Variant of subtype String.

static java.lang.String CStr(long expression)
          Returns an expression that has been converted to a Variant of subtype String.

static java.lang.String CStr(short expression)
          Returns an expression that has been converted to a Variant of subtype String.

static java.lang.String CStr(java.lang.String expression)
          Returns an expression that has been converted to a Variant of subtype String.

static java.lang.String CStr(variant expression)
          Returns an expression that has been converted to a Variant of subtype String.

static java.lang.String CStr(vbcurrency expression)
          Returns an expression that has been converted to a Variant of subtype String.

static java.lang.String CStr(vbdate da)
          Returns an expression that has been converted to a Variant of subtype String.

static vbdate Date()
          Returns the current system date.

static vbdate DateAdd(java.lang.String interval, double number, vbdate date)
          Returns a date to which a specified time interval has been added.

static double DateDiff(java.lang.String interval, vbdate date1, vbdate date2)
          Returns the number of intervals between two dates.

static double DateDiff(java.lang.String interval, vbdate date1, vbdate date2, double firstdayofweek)
          Returns the number of intervals between two dates.

static double DateDiff(java.lang.String interval, vbdate date1, vbdate date2, double firstdayofweek, double firstweekofyear)
          Returns the number of intervals between two dates.

static int DatePart(java.lang.String interval, vbdate date)
          Returns the specified part of a given date.

static int DatePart(java.lang.String interval, vbdate date, double firstdayofweek)
          Returns the specified part of a given date.

static int DatePart(java.lang.String interval, vbdate date, double firstdayofweek, double firstweekofyear)
          Returns the specified part of a given date.

static vbdate DateSerial(double year, double month, double day)
          Returns a vbdate for a specified year, month, and day.

static vbdate DateValue(double date)
          Returns a vbdate.

static vbdate DateValue(java.lang.String date)
          Returns a vbdate.

static vbdate DateValue(variant date)
          Returns a vbdate.

static vbdate DateValue(vbdate date)
          Returns a vbdate.

static int Day(double date)
          Returns a whole number between 1 and 31, inclusive, representing the day of the month.

static int Day(java.lang.String date)
          Returns a whole number between 1 and 31, inclusive, representing the day of the month.

static int Day(variant date)
          Returns a whole number between 1 and 31, inclusive, representing the day of the month.

static int Day(vbdate date)
          Returns a whole number between 1 and 31, inclusive, representing the day of the month.

static java.lang.String Escape(java.lang.String str)
          Returns a string value (in Unicode format) that contains the contents of charstring.

static java.lang.String Eval(java.lang.String str)
          Evaluates an expression and returns the result.

static double Exp(boolean number)
          Returns e (the base of natural logarithms) raised to a power.

static double Exp(double number)
          Returns e (the base of natural logarithms) raised to a power.

static double Exp(java.lang.String number)
          Returns e (the base of natural logarithms) raised to a power.

static double Exp(variant number)
          Returns e (the base of natural logarithms) raised to a power.

static double Exp(vbcurrency number)
          Returns e (the base of natural logarithms) raised to a power.

static double Exp(vbdate number)
          Returns e (the base of natural logarithms) raised to a power.

static vbarray Filter(variant inputStrings, java.lang.String value)
          Returns a zero-based array containing a subset of a string array based on a specified filter criteria.

static vbarray Filter(variant inputStrings, java.lang.String value, boolean include)
          Returns a zero-based array containing a subset of a string array based on a specified filter criteria.

static vbarray Filter(variant inputStrings, java.lang.String value, boolean include, double compare)
          Returns a zero-based array containing a subset of a string array based on a specified filter criteria.

static vbarray Filter(vbarray inputStrings, java.lang.String value)
          Returns a zero-based array containing a subset of a string array based on a specified filter criteria.

static vbarray Filter(vbarray inputStrings, java.lang.String value, boolean include)
          Returns a zero-based array containing a subset of a string array based on a specified filter criteria.

static vbarray Filter(vbarray inputStrings, java.lang.String value, boolean include, double compare)
          Returns a zero-based array containing a subset of a string array based on a specified filter criteria.

static int Fix(boolean number)
          Returns the integer portion of a number.

static int Fix(double number)
          Returns the integer portion of a number.

static int Fix(java.lang.String number)
          Returns the integer portion of a number.

static int Fix(variant number)
          Returns the integer portion of a number.

static int Fix(vbcurrency number)
          Returns the integer portion of a number.

static int Fix(vbdate number)
          Returns the integer portion of a number.

static java.lang.String FormatCurrency(double expression)
          Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.

static java.lang.String FormatCurrency(double expression, double NumDigitsAfterDecimal)
          Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.

static java.lang.String FormatCurrency(double expression, double NumDigitsAfterDecimal, double IncludeLeadingDigit)
          Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.

static java.lang.String FormatCurrency(double expression, double NumDigitsAfterDecimal, double IncludeLeadingDigit, double UseParensForNegativeNumbers)
          Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.

static java.lang.String FormatCurrency(double expression, double NumDigitsAfterDecimal, double IncludeLeadingDigit, double UseParensForNegativeNumbers, double GroupDigits)
          Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.

static java.lang.String FormatCurrency(variant expression)
          Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.

static java.lang.String FormatDateTime(double date)
          Returns an expression formatted as a date or time.

static java.lang.String FormatDateTime(double date, double NamedFormat)
          Returns an expression formatted as a date or time.

static java.lang.String FormatDateTime(java.lang.String date)
          Returns an expression formatted as a date or time.

static java.lang.String FormatDateTime(java.lang.String date, double NamedFormat)
          Returns an expression formatted as a date or time.

static java.lang.String FormatDateTime(variant date)
          Returns an expression formatted as a date or time.

static java.lang.String FormatDateTime(variant date, double NamedFormat)
          Returns an expression formatted as a date or time.

static java.lang.String FormatDateTime(vbdate date)
          Returns an expression formatted as a date or time.

static java.lang.String FormatDateTime(vbdate date, double NamedFormat)
          Returns an expression formatted as a date or time.

static java.lang.String FormatNumber(double expression)
          Returns an expression formatted as a number.

static java.lang.String FormatNumber(double expression, double NumDigitsAfterDecimal)
          Returns an expression formatted as a number.

static java.lang.String FormatNumber(double expression, double NumDigitsAfterDecimal, double IncludeLeadingDigit)
          Returns an expression formatted as a number.

static java.lang.String FormatNumber(double expression, double NumDigitsAfterDecimal, double IncludeLeadingDigit, double UseParensForNegativeNumbers)
          Returns an expression formatted as a number.

static java.lang.String FormatNumber(double expression, double NumDigitsAfterDecimal, double IncludeLeadingDigit, double UseParensForNegativeNumbers, double GroupDigits)
          Returns an expression formatted as a number.

static java.lang.String FormatNumber(variant expression)
          Returns an expression formatted as a number.

static java.lang.String FormatPercent(double expression)
          Returns an expression formatted as a percentage (multiplied by 100) with a trailing % character.

static java.lang.String FormatPercent(double expression, double NumDigitsAfterDecimal)
          Returns an expression formatted as a percentage (multiplied by 100) with a trailing % character.

static java.lang.String FormatPercent(double expression, double NumDigitsAfterDecimal, double IncludeLeadingDigit)
          Returns an expression formatted as a percentage (multiplied by 100) with a trailing % character.

static java.lang.String FormatPercent(double expression, double NumDigitsAfterDecimal, double IncludeLeadingDigit, double UseParensForNegativeNumbers)
          Returns an expression formatted as a percentage (multiplied by 100) with a trailing % character.

static java.lang.String FormatPercent(double expression, double NumDigitsAfterDecimal, double IncludeLeadingDigit, double UseParensForNegativeNumbers, double GroupDigits)
          Returns an expression formatted as a percentage (multiplied by 100) with a trailing % character.

static java.lang.String FormatPercent(variant expression)
          Returns an expression formatted as a percentage (multiplied by 100) with a trailing % character.

static int GetLocale()
          Returns the current locale ID value.

static java.lang.String Hex(boolean number)
          Returns a string representing the hexadecimal value of a number.

static java.lang.String Hex(double number)
          Returns a string representing the hexadecimal value of a number.

static java.lang.String Hex(int number)
          Returns a string representing the hexadecimal value of a number.

static java.lang.String Hex(java.lang.String number)
          Returns a string representing the hexadecimal value of a number.

static java.lang.String Hex(variant number)
          Returns a string representing the hexadecimal value of a number.

static java.lang.String Hex(vbcurrency number)
          Returns a string representing the hexadecimal value of a number.

static java.lang.String Hex(vbdate number)
          Returns a string representing the hexadecimal value of a number.

static int Hour(double time)
          Returns a whole number between 0 and 23, inclusive, representing the hour of the day.

static int Hour(java.lang.String time)
          Returns a whole number between 0 and 23, inclusive, representing the hour of the day.

static int Hour(variant time)
          Returns a whole number between 0 and 23, inclusive, representing the hour of the day.

static int Hour(vbdate time)
          Returns a whole number between 0 and 23, inclusive, representing the hour of the day.

static int InStr(double start, java.lang.String string1, java.lang.String string2)
          Returns the position of the first occurrence of one string within another.

static int InStr(double start, java.lang.String string1, java.lang.String string2, double compare)
          Returns the position of the first occurrence of one string within another.

static int InStr(java.lang.String string1, java.lang.String string2)
          Returns the position of the first occurrence of one string within another.

static int InStrRev(java.lang.String string1, java.lang.String string2)
          Returns the position of an occurrence of one string within another, from the end of string.

static int InStrRev(java.lang.String string1, java.lang.String string2, double start)
          Returns the position of an occurrence of one string within another, from the end of string.

static int InStrRev(java.lang.String string1, java.lang.String string2, double start, double compare)
          Returns the position of an occurrence of one string within another, from the end of string.

static short Int(boolean number)
          Returns the integer portion of a number.

static double Int(double number)
          Returns the integer portion of a number.

static float Int(float number)
          Returns the integer portion of a number.

static int Int(int number)
          Returns the integer portion of a number.

static long Int(long number)
          Returns the integer portion of a number.

static short Int(short number)
          Returns the integer portion of a number.

static double Int(java.lang.String number)
          Returns the integer portion of a number.

static variant Int(variant number)
          Returns the integer portion of a number.

static vbcurrency Int(vbcurrency number)
          Returns the integer portion of a number.

static vbdate Int(vbdate vd)
          Returns the integer portion of a number.

static boolean IsArray(variant obj)
          Returns a Boolean value indicating whether a variable is an array.

static boolean IsArray(vbarray obj)
          Returns a Boolean value indicating whether a variable is an array.

static boolean IsDate(double d)
          Returns a Boolean value indicating whether an expression can be converted to a date.

static boolean IsDate(java.lang.String d)
          Returns a Boolean value indicating whether an expression can be converted to a date.

static boolean IsDate(variant d)
          Returns a Boolean value indicating whether an expression can be converted to a date.

static boolean IsDate(vbdate d)
          Returns a Boolean value indicating whether an expression can be converted to a date.

static boolean IsEmpty(boolean d)
          Returns a boolean value indicating whether a variable has been initialized.

static boolean IsEmpty(double d)
          Returns a boolean value indicating whether a variable has been initialized.

static boolean IsEmpty(java.lang.String d)
          Returns a boolean value indicating whether a variable has been initialized.

static boolean IsEmpty(variant d)
          Returns a boolean value indicating whether a variable has been initialized.

static boolean IsEmpty(vbdate d)
          Returns a boolean value indicating whether a variable has been initialized.

static boolean IsNull(double expression)
          Returns a boolean value that indicates whether An expression contains no valid data ( Null).

static boolean IsNull(java.lang.Object expression)
          Returns a boolean value that indicates whether An expression contains no valid data ( Null).

static boolean IsNull(java.lang.String expression)
          Returns a boolean value that indicates whether An expression contains no valid data ( Null).

static boolean IsNull(variant expression)
          Returns a boolean value that indicates whether An expression contains no valid data ( Null).

static boolean IsNull(vbdate expression)
          Returns a boolean value that indicates whether An expression contains no valid data ( Null).

static boolean IsNumeric(double expression)
          Returns a boolean value indicating whether An expression can be evaluated as a number.

static boolean IsNumeric(java.lang.String expression)
          Returns a boolean value indicating whether An expression can be evaluated as a number.

static boolean IsNumeric(variant expression)
          Returns a boolean value indicating whether An expression can be evaluated as a number.

static boolean IsNumeric(vbcurrency expression)
          Returns a boolean value indicating whether An expression can be evaluated as a number.

static boolean IsNumeric(vbdate expression)
          Returns a boolean value indicating whether An expression can be evaluated as a number.

static boolean IsObject(boolean b)
          Returns a Boolean value indicating whether an expression references a valid Java object.

static boolean IsObject(double obj)
          Returns a Boolean value indicating whether an expression references a valid Java object.

static boolean IsObject(java.lang.Object b)
          Returns a Boolean value indicating whether an expression references a valid Java object.

static boolean IsObject(java.lang.String obj)
          Returns a Boolean value indicating whether an expression references a valid Java object.

static boolean IsObject(variant obj)
          Returns a Boolean value indicating whether an expression references a valid Java object.

static boolean IsObject(vbdate b)
          Returns a Boolean value indicating whether an expression references a valid Java object.

static java.lang.String Join(variant a)
          Returns a string created by joining a number of substrings contained in an array.

static java.lang.String Join(variant a, java.lang.String b)
          Returns a string created by joining a number of substrings contained in an array.

static java.lang.String Join(vbarray a)
          Returns a string created by joining a number of substrings contained in an array.

static java.lang.String Join(vbarray a, java.lang.String b)
          Returns a string created by joining a number of substrings contained in an array.

static int LBound(java.lang.Object arrayname, double dimension)
          Returns the smallest available subscript for the indicated dimension of an array.

static int LBound(variant arrayname)
          Returns the smallest available subscript for the indicated dimension of an array.

static int LBound(variant arrayname, double dimension)
          Returns the smallest available subscript for the indicated dimension of an array.

static int LBound(vbarray arrayname)
          Returns the smallest available subscript for the indicated dimension of an array.

static int LBound(vbarray arrayname, double dimension)
          Returns the smallest available subscript for the indicated dimension of an array.

static java.lang.String LCase(boolean string)
          Returns a string that has been converted to lowercase.

static java.lang.String LCase(double string)
          Returns a string that has been converted to lowercase.

static java.lang.String LCase(java.lang.String string)
          Returns a string that has been converted to lowercase.

static java.lang.String LCase(variant string)
          Returns a string that has been converted to lowercase.

static java.lang.String LCase(vbcurrency string)
          Returns a string that has been converted to lowercase.

static java.lang.String LCase(vbdate string)
          Returns a string that has been converted to lowercase.

static java.lang.String Left(java.lang.String string, double length)
          Returns a specified number of characters from the left side of a string.

static int Len(boolean st)
          Returns the number of characters in a string.

static int Len(double st)
          Returns the number of characters in a string.

static int Len(int st)
          Returns the number of characters in a string.

static int Len(long string)
          Returns the number of characters in a string.

static int Len(java.lang.String string)
          Returns the number of characters in a string.

static int Len(variant st)
          Returns the number of characters in a string.

static int Len(vbcurrency st)
          Returns the number of characters in a string.

static int Len(vbdate st)
          Returns the number of characters in a string.

static double Log(boolean number)
          Returns the natural logarithm of a number.

static double Log(double number)
          Returns the natural logarithm of a number.

static double Log(java.lang.String number)


static double Log(variant number)
          Returns the natural logarithm of a number.

static double Log(vbcurrency number)
          Returns the natural logarithm of a number.

static double Log(vbdate number)
          Returns the natural logarithm of a number.

static java.lang.String LTrim(boolean string)
          Returns a copy of a string without leading spaces.

static java.lang.String LTrim(double string)
          Returns a copy of a string without leading spaces.

static java.lang.String LTrim(java.lang.String string)
          Returns a copy of a string without leading spaces.

static java.lang.String LTrim(variant string)
          Returns a copy of a string without leading spaces.

static java.lang.String LTrim(vbcurrency string)
          Returns a copy of a string without leading spaces.

static java.lang.String LTrim(vbdate string)
          Returns a copy of a string without leading spaces.

static java.lang.String Mid(java.lang.String string, double start)
          Returns a specified number of characters from a string.

static java.lang.String Mid(java.lang.String string, double start, double length)
          Returns a specified number of characters from a string.

static int Minute(double time)
          Returns a whole number between 0 and 59, inclusive, representing the minute of the hour.

static int Minute(java.lang.String time)
          Returns a whole number between 0 and 59, inclusive, representing the minute of the hour.

static int Minute(variant time)
          Returns a whole number between 0 and 59, inclusive, representing the minute of the hour.

static int Minute(vbdate time)
          Returns a whole number between 0 and 59, inclusive, representing the minute of the hour.

static int Month(double date)
          Returns a whole number between 1 and 12, inclusive, representing the month of the year.

static int Month(java.lang.String date)
          Returns a whole number between 1 and 12, inclusive, representing the month of the year.

static int Month(variant date)
          Returns a whole number between 1 and 12, inclusive, representing the month of the year.

static int Month(vbdate date)
          Returns a whole number between 1 and 12, inclusive, representing the month of the year.

static java.lang.String MonthName(boolean month)
          Returns a string indicating the specified month.

static java.lang.String MonthName(boolean month, boolean abbreviate)
          Returns a string indicating the specified month.

static java.lang.String MonthName(double month)
          Returns a string indicating the specified month.

static java.lang.String MonthName(double month, boolean abbreviate)
          Returns a string indicating the specified month.

static vbdate Now()
          Returns the current date and time according to the setting of your computer's system date and time.

static java.lang.String Oct(boolean number)
          Returns a string representing the octal value of a number.

static java.lang.String Oct(double number)
          Returns a string representing the octal value of a number.

static java.lang.String Oct(int number)
          Returns a string representing the octal value of a number.

static java.lang.String Oct(java.lang.String number)
          Returns a string representing the octal value of a number.

static java.lang.String Oct(variant number)
          Returns a string representing the octal value of a number.

static java.lang.String Oct(vbcurrency number)
          Returns a string representing the octal value of a number.

static java.lang.String Oct(vbdate number)
          Returns a string representing the octal value of a number.

static void Randomize()
          Initializes the random-number generator.

static void Randomize(double db)
          Initializes the random-number generator.

static java.lang.String Replace(java.lang.String expression, java.lang.String find, java.lang.String replacewith)
          Returns a string in which a specified substring has been replaced with another substring a specified number of times.

static java.lang.String Replace(java.lang.String expression, java.lang.String find, java.lang.String replacewith, double start)
          Returns a string in which a specified substring has been replaced with another substring a specified number of times.

static java.lang.String Replace(java.lang.String expression, java.lang.String find, java.lang.String replacewith, double start, double count)
          Returns a string in which a specified substring has been replaced with another substring a specified number of times.

static java.lang.String Replace(java.lang.String expression, java.lang.String find, java.lang.String replacewith, double start, double count, double compare)
          Returns a string in which a specified substring has been replaced with another substring a specified number of times.

static int RGB(double red, double green, double blue)
          Returns a whole number representing an RGB color value.

static java.lang.String Right(java.lang.String string, double length)
          Returns a specified number of characters from the right side of a string.

static double Rnd()
          Returns a random number.

static double Rnd(double number)
          Returns a random number.

static boolean Round(boolean expression)
          Returns a number rounded to a specified number of decimal places.

static double Round(double expression)
          Returns a number rounded to a specified number of decimal places.

static double Round(double expression, double numdecimalplaces)
          Returns a number rounded to a specified number of decimal places.

static double Round(java.lang.String expression)
          Returns a number rounded to a specified number of decimal places.

static double Round(variant expression)
          Returns a number rounded to a specified number of decimal places.

static vbcurrency Round(vbcurrency expression)
          Returns a number rounded to a specified number of decimal places.

static vbcurrency Round(vbcurrency expression, double numdecimalplaces)
          Returns a number rounded to a specified number of decimal places.

static vbdate Round(vbdate expression)
          Returns a number rounded to a specified number of decimal places.

static vbdate Round(vbdate expression, double numdecimalplaces)
          Returns a number rounded to a specified number of decimal places.

static java.lang.String RTrim(boolean string)
          Returns a copy of a string without trailing spaces.

static java.lang.String RTrim(double string)
          Returns a copy of a string without trailing spaces.

static java.lang.String RTrim(java.lang.String string)
          Returns a copy of a string without trailing spaces.

static java.lang.String RTrim(variant string)
          Returns a copy of a string without trailing spaces.

static java.lang.String RTrim(vbcurrency string)
          Returns a copy of a string without trailing spaces.

static java.lang.String RTrim(vbdate string)
          Returns a copy of a string without trailing spaces.

static java.lang.String ScriptEngine()
          Returns "VBScript"

static int ScriptEngineBuildVersion()
          Returns the build version number of the scripting engine in use.

static int ScriptEngineMajorVersion()
          Returns the major version number of the scripting engine in use.

static int ScriptEngineMinorVersion()
          Returns the minor version number of the scripting engine in use.

static int Second(double time)
          Returns a whole number between 0 and 59, inclusive, representing the second of the minute.

static int Second(java.lang.String time)
          Returns a whole number between 0 and 59, inclusive, representing the second of the minute.

static int Second(variant time)
          Returns a whole number between 0 and 59, inclusive, representing the second of the minute.

static int Second(vbdate time)
          Returns a whole number between 0 and 59, inclusive, representing the second of the minute.

static int SetLocale(int lcid)
          Sets the global locale and returns the previous locale.

static int SetLocale(java.lang.String loc)
          Sets the global locale and returns the previous locale.

static int Sgn(boolean number)
          Returns an integer indicating the sign of a number.

static int Sgn(double number)
          Returns an integer indicating the sign of a number.

static int Sgn(java.lang.String number)
          Returns an integer indicating the sign of a number.

static int Sgn(variant number)
          Returns an integer indicating the sign of a number.

static int Sgn(vbcurrency number)
          Returns an integer indicating the sign of a number.

static int Sgn(vbdate number)
          Returns an integer indicating the sign of a number.

static double Sin(boolean number)
          Returns the sine of an angle.

static double Sin(double number)
          Returns the sine of an angle.

static double Sin(java.lang.String number)
          Returns the sine of an angle.

static double Sin(variant number)
          Returns the sine of an angle.

static double Sin(vbcurrency number)
          Returns the sine of an angle.

static double Sin(vbdate number)
          Returns the sine of an angle.

static java.lang.String Space(boolean number)
          Returns a string consisting of the specified number of spaces.

static java.lang.String Space(double number)
          Returns a string consisting of the specified number of spaces.

static java.lang.String Space(java.lang.String number)
          Returns a string consisting of the specified number of spaces.

static java.lang.String Space(variant number)
          Returns a string consisting of the specified number of spaces.

static vbarray Split(boolean expression)
          Returns a zero-based, one-dimensional array containing a specified number of substrings.

static vbarray Split(double expression)
          Returns a zero-based, one-dimensional array containing a specified number of substrings.

static vbarray Split(java.lang.String expression)
          Returns a zero-based, one-dimensional array containing a specified number of substrings.

static vbarray Split(java.lang.String expression, java.lang.String delimiter)
          Returns a zero-based, one-dimensional array containing a specified number of substrings.

static vbarray Split(java.lang.String expression, java.lang.String delimiter, double count)
          Returns a zero-based, one-dimensional array containing a specified number of substrings.

static vbarray Split(java.lang.String expression, java.lang.String delimiter, double count, double compare)
          Returns a zero-based, one-dimensional array containing a specified number of substrings.

static double Sqr(boolean number)
          Returns the square root of a number.

static double Sqr(double number)
          Returns the square root of a number.

static double Sqr(java.lang.String number)
          Returns the square root of a number.

static double Sqr(variant number)
          Returns the square root of a number.

static double Sqr(vbcurrency number)
          Returns the square root of a number.

static double Sqr(vbdate number)
          Returns the square root of a number.

static int StrComp(java.lang.String string1, java.lang.String string2)
          Returns a value indicating the result of a string comparison.

static int StrComp(java.lang.String string1, java.lang.String string2, double compare)
          Returns a value indicating the result of a string comparison.

static java.lang.String String(double number, double character)
          Returns a repeating character string of the length specified.

static java.lang.String String(double number, java.lang.String character)
          Returns a repeating character string of the length specified.

static java.lang.String String(double number, variant cv)
          Returns a repeating character string of the length specified.

static java.lang.String StrReverse(boolean string1)
          Returns a string in which the character order of a specified string is reversed.

static java.lang.String StrReverse(double string1)
          Returns a string in which the character order of a specified string is reversed.

static java.lang.String StrReverse(java.lang.String string1)
          Returns a string in which the character order of a specified string is reversed.

static java.lang.String StrReverse(variant string1)
          Returns a string in which the character order of a specified string is reversed.

static java.lang.String StrReverse(vbcurrency string1)
          Returns a string in which the character order of a specified string is reversed.

static java.lang.String StrReverse(vbdate string1)
          Returns a string in which the character order of a specified string is reversed.

static double Tan(boolean number)
          Returns the tangent of an angle.

static double Tan(double number)
          Returns the tangent of an angle.

static double Tan(java.lang.String number)
          Returns the tangent of an angle.

static double Tan(variant number)
          Returns the tangent of an angle.

static double Tan(vbcurrency number)
          Returns the tangent of an angle.

static double Tan(vbdate number)
          Returns the tangent of an angle.

static vbdate Time()
          Returns a vbdate indicating the current system time.

static double Timer()
          Returns the number of seconds that have elapsed since 12:00 AM (midnight).

static vbdate TimeSerial(double hour, double minute, double second)
          Returns a vbdate containing the time for a specific hour, minute, and second.

static vbdate TimeValue(double time)
          Returns a vbdate containing the time.

static vbdate TimeValue(java.lang.String time)
          TimeValue

static vbdate TimeValue(variant time)
          Returns a vbdate containing the time.

static vbdate TimeValue(vbdate time)
          Returns a vbdate containing the time.

static java.lang.String Trim(boolean string)
          Returns a copy of a string without both leading and trailing spaces.

static java.lang.String Trim(double string)
          Returns a copy of a string without both leading and trailing spaces.

static java.lang.String Trim(java.lang.String string)
          Returns a copy of a string without both leading and trailing spaces.

static java.lang.String Trim(variant string)
          Returns a copy of a string without both leading and trailing spaces.

static java.lang.String Trim(vbcurrency string)
          Returns a copy of a string without both leading and trailing spaces.

static java.lang.String Trim(vbdate string)
          Returns a copy of a string without both leading and trailing spaces.

static java.lang.String TypeName(boolean obj)
          Returns a string that provides Variant subtype information about a variable.

static java.lang.String TypeName(double obj)
          Returns a string that provides Variant subtype information about a variable.

static java.lang.String TypeName(float obj)
          Returns a string that provides Variant subtype information about a variable.

static java.lang.String TypeName(int obj)
          Returns a string that provides Variant subtype information about a variable.

static java.lang.String TypeName(java.lang.Object obj)
          Returns a string that provides Variant subtype information about a variable.

static java.lang.String TypeName(short obj)
          Returns a string that provides Variant subtype information about a variable.

static java.lang.String TypeName(java.lang.String obj)
          Returns a string that provides Variant subtype information about a variable.

static java.lang.String TypeName(variant obj)
          Returns a string that provides Variant subtype information about a variable.

static java.lang.String TypeName(vbcurrency obj)
          Returns a string that provides Variant subtype information about a variable.

static java.lang.String TypeName(vbdate obj)
          Returns a string that provides Variant subtype information about a variable.

static int UBound(java.lang.Object array)
          Returns the largest available subscript for the indicated dimension of an array.

static int UBound(java.lang.Object array, int dimension)
          Returns the largest available subscript for the indicated dimension of an array.

static int UBound(variant array)
          Returns the largest available subscript for the indicated dimension of an array.

static int UBound(variant array, int dimension)
          Returns the largest available subscript for the indicated dimension of an array.

static int UBound(vbarray array)
          Returns the largest available subscript for the indicated dimension of an array.

static int UBound(vbarray array, int dimension)
          Returns the largest available subscript for the indicated dimension of an array.

static java.lang.String UCase(boolean string)
          Returns a string that has been converted to uppercase.

static java.lang.String UCase(double string)
          Returns a string that has been converted to uppercase.

static java.lang.String UCase(java.lang.String string)
          Returns a string that has been converted to uppercase.

static java.lang.String UCase(variant string)
          Returns a string that has been converted to uppercase.

static java.lang.String UCase(vbcurrency string)
          Returns a string that has been converted to uppercase.

static java.lang.String UCase(vbdate string)
          Returns a string that has been converted to uppercase.

static java.lang.String Unescape(java.lang.String str)
          Returns a string value that contains the contents of charstring.

static int VarType(boolean obj)
          Returns a value indicating the subtype of a variable.

static int VarType(byte obj)
          Returns a value indicating the subtype of a variable.

static int VarType(double obj)
          Returns a value indicating the subtype of a variable.

static int VarType(float obj)
          Returns a value indicating the subtype of a variable.

static int VarType(int obj)
          Returns a value indicating the subtype of a variable.

static int VarType(java.lang.Object obj)
          Returns a value indicating the subtype of a variable.

static int VarType(short obj)
          Returns a value indicating the subtype of a variable.

static int VarType(java.lang.String obj)
          Returns a value indicating the subtype of a variable.

static int VarType(variant obj)
          Returns a value indicating the subtype of a variable.

static int VarType(vbcurrency obj)
          Returns a value indicating the subtype of a variable.

static int VarType(vbdate obj)
          Returns a value indicating the subtype of a variable.

static int Weekday(variant date)
          Returns a whole number representing the day of the week.

static int Weekday(vbdate date)
          Returns a whole number representing the day of the week.

static int Weekday(vbdate date, double firstdayofweek)
          Returns a string indicating the specified month.

static java.lang.String WeekdayName(boolean weekday)
          Returns a whole number representing the day of the week.

static java.lang.String WeekdayName(boolean weekday, boolean abbreviate)
          Returns a whole number representing the day of the week.

static java.lang.String WeekdayName(double weekday)
          Returns a whole number representing the day of the week.

static java.lang.String WeekdayName(double weekday, boolean abbreviate)
          Returns a whole number representing the day of the week.

static java.lang.String WeekdayName(double weekday, boolean abbreviate, double firstdayofweek)
          Returns a whole number representing the day of the week.

static java.lang.String WeekdayName(java.lang.String weekday)
          Returns a whole number representing the day of the week.

static java.lang.String WeekdayName(java.lang.String weekday, boolean abbreviate, double firstdayofweek)
          Returns a whole number representing the day of the week.

static java.lang.String WeekdayName(variant weekday)
          Returns a whole number representing the day of the week.

static java.lang.String WeekdayName(variant weekday, boolean abbreviate, double firstdayofweek)
          Returns a whole number representing the day of the week.

static java.lang.String WeekdayName(vbdate weekday)
          Returns a whole number representing the day of the week.

static int Year(double date)
          Returns a whole number representing the year.

static int Year(java.lang.String date)
          Returns a whole number representing the year.

static int Year(variant date)
          Returns a whole number representing the year.

static int Year(vbdate date)
          Returns a whole number representing the year.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

vb

public vb()

Method Detail

Abs

public static int Abs(int number)
               throws java.lang.Exception

Returns the absolute value of an integer number. The absolute value of a number is its unsigned magnitude.

Parameters:: number - integer number.
Returns:: the absolute value of a number.

Abs

public static double Abs(double number)
                  throws java.lang.Exception

Returns the absolute value of a double number. The absolute value of a number is its unsigned magnitude.

Parameters:: number - double number.
Returns:: the absolute value of a number.

Abs

public static double Abs(java.lang.String number)
                  throws java.lang.Exception

Returns the absolute value of a string. The absolute value of a number is its unsigned magnitude.

Parameters:: number - String number. The string must be converted to numeric.
Returns:: the absolute value of a string.
Throws:: throw - an Exception. If string number can't be interpreted as a numeric value, a run-time error occurs.

Abs

public static variant Abs(variant number)
                   throws java.lang.Exception

Returns the absolute value of a variant. The absolute value of a number is its unsigned magnitude.

Parameters:: number - a variant.
Returns:: the absolute value of a variant. If the number is null, return an variant whose type is vbNull.
Throws:: throw - an Exception. If the argument can't be interpreted as a numeric value, a run-time error occurs.

Abs

public static short Abs(boolean number)
                 throws java.lang.Exception

Returns the absolute value of a boolean number. The absolute value of a number is its unsigned magnitude.

Parameters:: number - a boolean value.
Returns:: the absolute value of a number. If the number is true, return 1, otherwise return 0.

Abs

public static vbcurrency Abs(vbcurrency number)
                      throws java.lang.Exception

Returns the absolute value of a vbcurrency. The absolute value of a number is its unsigned magnitude.

Parameters:: number - a vbcurrency value.
Returns:: the absolute value of a vbCurrency.

Abs

public static vbdate Abs(vbdate number)
                  throws java.lang.Exception

Returns the absolute value of a vbdate. The absolute value of a number is its unsigned magnitude.

Parameters:: number - a vbdate value.
Returns:: the absolute value of vbdate.

Asc

public static short Asc(java.lang.String string)
                 throws java.lang.Exception

Returns the ANSI character code corresponding to the first letter in a string.

Parameters:: string - the argument is any valid string expression.
Returns:: the ANSI character code.
Throws:: if - the string contains no characters, a run-time error occurs.

Asc

public static short Asc(int string)
                 throws java.lang.Exception

Returns the ANSI character code corresponding to the first letter in a numeric string.

Parameters:: string - the argument is a int numeric.
Returns:: the ANSI character code.

Asc

public static short Asc(long string)
                 throws java.lang.Exception

Returns the ANSI character code corresponding to the first letter in a numeric string.

Parameters:: string - the argument is a long numeric.
Returns:: the ANSI character code.

Asc

public static short Asc(float string)
                 throws java.lang.Exception

Returns the ANSI character code corresponding to the first letter in a numeric string.

Parameters:: string - the argument is a float numeric.
Returns:: the ANSI character code.

Asc

public static short Asc(boolean string)
                 throws java.lang.Exception

Returns the ANSI character code corresponding to the first letter in a boolean string.

Parameters:: string - the argument is a boolean value.
Returns:: If the argument is true, reutrns the ANSI character code of 'T', otherwise return code 'F'.

Asc

public static short Asc(double string)
                 throws java.lang.Exception

Returns the ANSI character code corresponding to the first letter in a numeric string.

Parameters:: string - the argument is double expression.
Returns:: the ANSI character code.

AscB

public static short AscB(java.lang.String string)
                  throws java.lang.Exception

Do not support AscB Function.

AscB

public static short AscB(double string)
                  throws java.lang.Exception

Do not support AscB Function.

AscB

public static short AscB(boolean string)
                  throws java.lang.Exception

Do not support AscB Function.

AscW

public static short AscW(java.lang.String string)
                  throws java.lang.Exception

Do not support AscW Function.

AscW

public static short AscW(double string)
                  throws java.lang.Exception

Do not support AscW Function.

AscW

public static short AscW(boolean string)
                  throws java.lang.Exception

Do not support AscW Function.

Atn

public static double Atn(double number)
                  throws java.lang.Exception

Returns the arctangent of a number.

Parameters:: number - the argument can be any valid numeric expression.
Returns:: the arctangent of a number.

Atn

public static double Atn(java.lang.String number)
                  throws java.lang.Exception

Returns the arctangent of a numeric string.

Parameters:: number - the argument can be any valid string expression that can be converted to numeric.
Returns:: the arctangent of a numeric string.
Throws:: if - the argument is not a numeric string, a runtime error ocurrs.

Atn

public static double Atn(boolean number)
                  throws java.lang.Exception

Returns the arctangent of a boolean value.

Parameters:: number - a boolean value.
Returns:: the arctangent of a boolean value.

CBool

public static boolean CBool(double expression)
                     throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype boolean.

Parameters:: expression - The argument is a numeric expression.
Returns:: True or False.

CBool

public static boolean CBool(vbdate expression)
                     throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype boolean.

Parameters:: expression - The argument is a vbdate expression.
Returns:: True or False.

CBool

public static boolean CBool(vbcurrency expression)
                     throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype boolean.

Parameters:: expression - The argument is a vbcurrency expression.
Returns:: True or False.

CBool

public static boolean CBool(java.lang.String expression)
                     throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype boolean.

Parameters:: expression - The argument is a string expression.
Returns:: True or False.
Throws:: throw - an Exception. If expression can't be interpreted as a numeric value, a run-time error occurs.

CBool

public static boolean CBool(boolean expression)
                     throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype boolean.

Parameters:: expression - The argument is a boolean value.
Returns:: True or False.

CBool

public static boolean CBool(variant expression)
                     throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype boolean.

Parameters:: expression - The argument is a variant.
Returns:: True or False.
Throws:: throw - an Exception. If expression can't be interpreted as a numeric value, a run-time error occurs.

CByte

public static short CByte(double expression)
                   throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Byte.

Parameters:: expression - The argument is a numeric expression.
Returns:: a byte value.
Throws:: throw - an Exception. If expression lies outside the acceptable range for the byte subtype, an error occurs.

CByte

public static short CByte(java.lang.String expression)
                   throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Byte.

Parameters:: expression - The argument is a string expression.
Returns:: a byte value.
Throws:: throw - an Exception. If expression can't be interpreted as a numeric value or lies outside the acceptable range for the byte subtype, an error occurs.

CByte

public static short CByte(boolean expression)
                   throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Byte.

Parameters:: expression - The argument is a boolean expression.
Returns:: if expression is False, return 0; if expression is True, return 255.

CByte

public static short CByte(vbdate expression)
                   throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Byte.

Parameters:: expression - The argument is a vbdate expression.
Returns:: a byte value.

CByte

public static short CByte(vbcurrency expression)
                   throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Byte.

Parameters:: expression - The argument is a vbcurrency expression.
Returns:: a byte value.

CByte

public static short CByte(variant expression)
                   throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Byte.

Parameters:: expression - The argument is a variant.
Returns:: a byte value.
Throws:: throw - an Exception. If the variant is NULL, an error occurs.

Chr

public static java.lang.String Chr(double charcode)
                            throws java.lang.Exception

Returns the character associated with the specified ANSI character code.

Parameters:: charcode - the argument is a numeric.
Returns:: the character.

Chr

public static java.lang.String Chr(java.lang.String charcode)
                            throws java.lang.Exception

Returns the character associated with the specified ANSI character code.

Parameters:: charcode - the argument is a string expression.
Returns:: the character.
Throws:: throw - an Exception. If the argument can't be interpreted as a numeric, an error occurs.

Chr

public static java.lang.String Chr(boolean charcode)
                            throws java.lang.Exception

Returns the character associated with the specified ANSI character code.

Parameters:: charcode - the argument is a boolean value.
Returns:: the character.

CCur

public static vbcurrency CCur(double expression)
                       throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Currency.

Parameters:: expression - the argument is a numeric expression.
Returns:: a vbcurrency object.

CCur

public static vbcurrency CCur(java.lang.String expression)
                       throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Currency.

Parameters:: expression - the argument is a numeric expression.
Returns:: a vbcurrency object.
Throws:: throw - an Exception. If the argument can't be interpreted as a numeric value, a run-time error occurs.

CCur

public static vbcurrency CCur(vbdate expression)
                       throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Currency.

Parameters:: expression - the argument is a vbdate.
Returns:: a vbcurrency object.

CCur

public static vbcurrency CCur(vbcurrency expression)
                       throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Currency.

Parameters:: expression - the argument is a vbcurrency.
Returns:: a vbcurrency object.

CCur

public static vbcurrency CCur(variant expression)
                       throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Currency.

Parameters:: expression - the argument is a variant.
Returns:: a vbcurrency object.
Throws:: throw - an exception. If the argument is NULL, a run-time error occurs.

CCur

public static vbcurrency CCur(boolean expression)
                       throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Currency.

Parameters:: expression - the argument is a boolean value.
Returns:: a vbcurrency object.

CDate

public static vbdate CDate(double date)
                    throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Date.

Parameters:: date - the argument is a numeric expression.
Returns:: a vbdate object.

CDate

public static vbdate CDate(java.lang.String date)
                    throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Date.

Parameters:: date - the argument is a string expression.
Returns:: a vbdate object.
Throws:: throw - an exception. If string expression can't be interpreted as a valid date/time string, a run-time error occurs.

CDate

public static vbdate CDate(vbdate date)
                    throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Date.

Parameters:: date - the argument is a vbdate.
Returns:: a vbdate object.

CDate

public static vbdate CDate(vbcurrency date)
                    throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Date.

Parameters:: date - the argument is a vbcurrency.
Returns:: a vbdate object.

CDate

public static vbdate CDate(boolean date)
                    throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Date.

Parameters:: date - the argument is a boolean value.
Returns:: a vbdate object.

CDate

public static vbdate CDate(variant date)
                    throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Date.

Parameters:: date - the argument is a variant.
Returns:: a vbdate object.
Throws:: throw - an exception. If the argument is NULL, a run-time error occurs.

CDbl

public static double CDbl(double expression)
                   throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Double.

Parameters:: expression - the argument is a numeric expression.
Returns:: a double value.

CDbl

public static double CDbl(java.lang.String expression)
                   throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Double.

Parameters:: expression - the argument is a string expression.
Returns:: a double value.
Throws:: throw - an exception. If string expression can't be interpreted as a numeric value, a run-time error occurs.

CDbl

public static double CDbl(vbdate expression)
                   throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Double.

Parameters:: expression - the argument is a vbdate.
Returns:: a double value.

CDbl

public static double CDbl(vbcurrency expression)
                   throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Double.

Parameters:: expression - the argument is a vbcurrency.
Returns:: a double value.

CDbl

public static double CDbl(boolean expression)
                   throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Double.

Parameters:: expression - the argument is a boolean value.
Returns:: if the argument is True, return -1; otherwise, return 0.

CDbl

public static double CDbl(java.lang.Object expression)
                   throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Double.

Parameters:: expression - the argument is an object.
Returns:: a double value.
Throws:: throw - an exception. If the argument is NULL, a run-time error occurs.

CDbl

public static double CDbl(variant expression)
                   throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Double.

Parameters:: expression - the argument is a variant.
Returns:: a double value.
Throws:: throw - an exception. If the argument is NULL, a run-time error occurs.

CInt

public static short CInt(double expression)
                  throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Integer.

Parameters:: expression - the argument is a numeric expression.
Returns:: an integer value.
Throws:: throw - an exception. If expression lies outside the acceptable range for the Integer subtype, an error occurs.

CInt

public static short CInt(java.lang.String expression)
                  throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Integer.

Parameters:: expression - the argument is a string expression.
Returns:: an integer value.
Throws:: throw - an exception. If expression can't be interpreted as a numeric value, an error occurs.

CInt

public static short CInt(vbdate expression)
                  throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Integer.

Parameters:: expression - the argument is a vbdate.
Returns:: an integer value.

CInt

public static short CInt(vbcurrency expression)
                  throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Integer.

Parameters:: expression - the argument is a vbcurrency.
Returns:: an integer value.

CInt

public static short CInt(boolean expression)
                  throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Integer.

Parameters:: expression - the argument is a boolean value.
Returns:: if the argument is True, return -1; otherwise, return 0.

CInt

public static short CInt(variant expression)
                  throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Integer.

Parameters:: expression - the argument is a variant.
Returns:: an integer value.
Throws:: throw - an exception. If the argument is NULL, an error occurs.

CLng

public static int CLng(double expression)
                throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Long.

Parameters:: expression - the argument is a numeric expression.
Returns:: a long value.
Throws:: throw - an exception. If expression lies outside the acceptable range for the Long subtype, an error occurs.

CLng

public static int CLng(java.lang.String expression)
                throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Long.

Parameters:: expression - the argument is a string expression.
Returns:: a long value.
Throws:: throw - an exception. If expression can't be interpreted as a numeric value, an error occurs.

CLng

public static int CLng(vbdate expression)
                throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Long.

Parameters:: expression - the argument is a vbdate.
Returns:: a long value.

CLng

public static int CLng(vbcurrency expression)
                throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Long.

Parameters:: expression - the argument is a vbcurrency.
Returns:: a long value.

CLng

public static int CLng(boolean expression)
                throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Long.

Parameters:: expression - the argument is a boolean value.
Returns:: if the argument is True, return -1; otherwise, return 0.

CLng

public static int CLng(variant expression)
                throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Long.

Parameters:: expression - the argument is a variant.
Returns:: a long value.
Throws:: throw - an exception. If the argument is NULL, an error occurs.

CSng

public static float CSng(double expression)
                  throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Single.

Parameters:: expression - the argument is a numeric expression.
Returns:: a single value.
Throws:: throw - an exception. If expression lies outside the acceptable range for the Single subtype, an error occurs.

CSng

public static float CSng(vbdate expression)
                  throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Single.

Parameters:: expression - the argument is a vbdate.
Returns:: a single value.

CSng

public static float CSng(vbcurrency expression)
                  throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Single.

Parameters:: expression - the argument is a vbcurrency.
Returns:: a single value.

CSng

public static float CSng(java.lang.String expression)
                  throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Single.

Parameters:: expression - the argument is a string expression.
Returns:: a single value.
Throws:: throw - an exception. If the argument can't be interpreted as a numeric value, an error occurs.

CSng

public static float CSng(boolean expression)
                  throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Single.

Parameters:: expression - the argument is a boolean value.
Returns:: if the argument is True, return -1; otherwise, return 0.

CSng

public static float CSng(variant expression)
                  throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype Single.

Parameters:: expression - the argument is a variant.
Returns:: a single value.
Throws:: throw - an exception. If the argument is NULL, an error occurs.

CStr

public static java.lang.String CStr(vbdate da)
                             throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype String.

Parameters:: da - the argument is a vbdate.
Returns:: a string expression.

CStr

public static java.lang.String CStr(vbcurrency expression)
                             throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype String.

Parameters:: expression - the argument is a vbcurrency.
Returns:: a string expression.

CStr

public static java.lang.String CStr(int expression)
                             throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype String.

Parameters:: expression - the argument is an integer value.
Returns:: a string expression.

CStr

public static java.lang.String CStr(short expression)
                             throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype String.

Parameters:: expression - the argument is a short value.
Returns:: a string expression.

CStr

public static java.lang.String CStr(long expression)
                             throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype String.

Parameters:: expression - the argument is a long value.
Returns:: a string expression.

CStr

public static java.lang.String CStr(double expression)
                             throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype String.

Parameters:: expression - the argument is a double value.
Returns:: a string expression.

CStr

public static java.lang.String CStr(java.lang.String expression)
                             throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype String.

Parameters:: expression - the argument is a string expression.
Returns:: a string expression.

CStr

public static java.lang.String CStr(boolean expression)
                             throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype String.

Parameters:: expression - the argument is a boolean value.
Returns:: the argument is True, return True; otherwise, return False.

CStr

public static java.lang.String CStr(variant expression)
                             throws java.lang.Exception

Returns an expression that has been converted to a Variant of subtype String.

Parameters:: expression - the argument is a variant.
Returns:: a string expression.
Throws:: throw - an exception. If the argument is NULL, a run-time error occurs.

Hex

public static java.lang.String Hex(int number)
                            throws java.lang.Exception

Returns a string representing the hexadecimal value of a number.

Parameters:: number - the argument is an integer value.
Returns:: the hexadecimal value of a number.

Hex

public static java.lang.String Hex(double number)
                            throws java.lang.Exception

Returns a string representing the hexadecimal value of a number.

Parameters:: number - the argument is a double value.
Returns:: the hexadecimal value of a number.

Hex

public static java.lang.String Hex(java.lang.String number)
                            throws java.lang.Exception

Returns a string representing the hexadecimal value of a number.

Parameters:: number - the argument is a string expression.
Returns:: the hexadecimal value of a number.
Throws:: throw - an exception. If the argument can't be interpreted as a numeric value, an error occurs.

Hex

public static java.lang.String Hex(boolean number)
                            throws java.lang.Exception

Returns a string representing the hexadecimal value of a number.

Parameters:: number - the argument is a boolean value.
Returns:: the hexadecimal value of a number.

Hex

public static java.lang.String Hex(variant number)
                            throws java.lang.Exception

Returns a string representing the hexadecimal value of a number.

Parameters:: number - the argument is a variant.
Returns:: the hexadecimal value of a number.

Hex

public static java.lang.String Hex(vbdate number)
                            throws java.lang.Exception

Returns a string representing the hexadecimal value of a number.

Parameters:: number - the argument is a vbdate.
Returns:: the hexadecimal value of a number.

Hex

public static java.lang.String Hex(vbcurrency number)
                            throws java.lang.Exception

Returns a string representing the hexadecimal value of a number.

Parameters:: number - the argument is a vbcurrency.
Returns:: the hexadecimal value of a number.

Oct

public static java.lang.String Oct(int number)
                            throws java.lang.Exception

Returns a string representing the octal value of a number.

Parameters:: number - the argument is an integer value.
Returns:: the octal value of a number.

Oct

public static java.lang.String Oct(double number)
                            throws java.lang.Exception

Returns a string representing the octal value of a number.

Parameters:: number - the argument is a double value.
Returns:: the octal value of a number.

Oct

public static java.lang.String Oct(java.lang.String number)
                            throws java.lang.Exception

Returns a string representing the octal value of a number.

Parameters:: number - the argument is a string expression.
Returns:: the octal value of a number.
Throws:: throw - an exception. If the argument can't be interpreted as a numeric value, an error occurs.

Oct

public static java.lang.String Oct(boolean number)
                            throws java.lang.Exception

Returns a string representing the octal value of a number.

Parameters:: number - the argument is a boolean value.
Returns:: the octal value of a number.

Oct

public static java.lang.String Oct(vbdate number)
                            throws java.lang.Exception

Returns a string representing the octal value of a number.

Parameters:: number - the argument is a vbdate.
Returns:: the octal value of a number.

Oct

public static java.lang.String Oct(vbcurrency number)
                            throws java.lang.Exception

Returns a string representing the octal value of a number.

Parameters:: number - the argument is a vbcurrency.
Returns:: the octal value of a number.

Oct

public static java.lang.String Oct(variant number)
                            throws java.lang.Exception

Returns a string representing the octal value of a number.

Parameters:: number - the argument is a variant.
Returns:: the octal value of a number.

Int

public static double Int(double number)
                  throws java.lang.Exception

Returns the integer portion of a number. If number is negative, return the first negative integer less than or equal to number.

Parameters:: number - the argument is a double value.
Returns:: the integer portion of a number.

Int

public static float Int(float number)
                 throws java.lang.Exception

Returns the integer portion of a number. If number is negative, return the first negative integer less than or equal to number.

Parameters:: number - the argument is a float value.
Returns:: the integer portion of a number.

Int

public static double Int(java.lang.String number)
                  throws java.lang.Exception

Returns the integer portion of a number. If number is negative, return the first negative integer less than or equal to number.

Parameters:: number - the argument is a string expression.
Returns:: the integer portion of a number.
Throws:: throw - an exception. If the argument can't be interpreted as a numeric value, an error occurs.

Int

public static int Int(int number)
               throws java.lang.Exception

Returns the integer portion of a number. If number is negative, return the first negative integer less than or equal to number.

Parameters:: number - the argument is an integer value.
Returns:: the integer portion of a number.

Int

public static short Int(short number)
                 throws java.lang.Exception

Returns the integer portion of a number. If number is negative, return the first negative integer less than or equal to number.

Parameters:: number - the argument is a short value.
Returns:: the integer portion of a number.

Int

public static long Int(long number)
                throws java.lang.Exception

Returns the integer portion of a number. If number is negative, return the first negative integer less than or equal to number.

Parameters:: number - the argument is a long value.
Returns:: the integer portion of a number.

Int

public static vbdate Int(vbdate vd)
                  throws java.lang.Exception

Returns the integer portion of a number. If number is negative, return the first negative integer less than or equal to number.

Parameters:: number - the argument is a vbdate.
Returns:: the integer portion of a number.

Int

public static short Int(boolean number)
                 throws java.lang.Exception

Returns the integer portion of a number. If number is negative, return the first negative integer less than or equal to number.

Parameters:: number - the argument is a boolean value.
Returns:: the argument is True, return -1; otherwise, return 0.

Int

public static variant Int(variant number)
                   throws java.lang.Exception

Returns the integer portion of a number. If number is negative, return the first negative integer less than or equal to number.

Parameters:: number - the argument is a variant.
Returns:: the integer portion of a number.

Int

public static vbcurrency Int(vbcurrency number)
                      throws java.lang.Exception

Returns the integer portion of a number. If number is negative, return the first negative integer less than or equal to number.

Parameters:: number - the argument is a vbcurrency.
Returns:: the integer portion of a number.

Fix

public static int Fix(double number)
               throws java.lang.Exception

Returns the integer portion of a number. If number is negative, return the first negative integer greater than or equal to number.

Parameters:: number - the argument is a double value.
Returns:: the integer portion of a number.

Fix

public static int Fix(java.lang.String number)
               throws java.lang.Exception

Returns the integer portion of a number. If number is negative, return the first negative integer greater than or equal to number.

Parameters:: number - the argument is a string expression.
Returns:: the integer portion of a number.
Throws:: throw - an exception. If the argument can't be interpreted as a numeric value, an error occurs.

Fix

public static int Fix(boolean number)
               throws java.lang.Exception

Returns the integer portion of a number. If number is negative, return the first negative integer greater than or equal to number.

Parameters:: number - the argument is a boolean value.
Returns:: the argument is True, return -1; otherwise, return 0.

Fix

public static int Fix(variant number)
               throws java.lang.Exception

Returns the integer portion of a number. If number is negative, return the first negative integer greater than or equal to number.

Parameters:: number - the argument is a variant.
Returns:: the integer portion of a number.

Fix

public static int Fix(vbdate number)
               throws java.lang.Exception

Returns the integer portion of a number. If number is negative, return the first negative integer greater than or equal to number.

Parameters:: number - the argument is a vbdate.
Returns:: the integer portion of a number.

Fix

public static int Fix(vbcurrency number)
               throws java.lang.Exception

Returns the integer portion of a number. If number is negative, return the first negative integer greater than or equal to number.

Parameters:: number - the argument is a vbcurrency.
Returns:: the integer portion of a number.

Sgn

public static int Sgn(double number)
               throws java.lang.Exception

Returns an integer indicating the sign of a number.

Parameters:: number - a double value.
Returns:: 1, 0 or -1 to indicate the sign of a number.

Sgn

public static int Sgn(java.lang.String number)
               throws java.lang.Exception

Returns an integer indicating the sign of a number.

Parameters:: number - a String that can convert to a number.
Returns:: 1, 0 or -1 to indicate the sign of a number.

Sgn

public static int Sgn(boolean number)
               throws java.lang.Exception

Returns an integer indicating the sign of a number.

Parameters:: number - a boolean value.
Returns:: -1, if the number is True. Otherwise 0.

Sgn

public static int Sgn(variant number)
               throws java.lang.Exception

Returns an integer indicating the sign of a number.

Parameters:: number - a variant.
Returns:: 1, 0 or -1 to indicate the sign of a number.

Sgn

public static int Sgn(vbdate number)
               throws java.lang.Exception

Returns an integer indicating the sign of a number.

Parameters:: number - a vbdate value.
Returns:: 1, 0 or -1 to indicate the sign of a number.

Sgn

public static int Sgn(vbcurrency number)
               throws java.lang.Exception

Returns an integer indicating the sign of a number.

Parameters:: number - a vbcurrency value.
Returns:: 1, 0 or -1 to indicate the sign of a number.

InStr

public static int InStr(java.lang.String string1,
                        java.lang.String string2)
                 throws java.lang.Exception

Returns the position of the first occurrence of one string within another.

Parameters:: string1 - a String expression being searched.; string2 - a String expression searched for.
Returns:: the position of the first occurrence of string2 with in strin1. If string1 or string2 is NULL, returns -2, (IIS returns NULL in this case).
See Also:: InStr(double start, String string1, String string2, double compare).

InStr

public static int InStr(double start,
                        java.lang.String string1,
                        java.lang.String string2)
                 throws java.lang.Exception

Returns the position of the first occurrence of one string within another.

Parameters:: start - A numeric expression that sets the starting position for each search. If omitted, search begins at the first character position. If start contains Null, an error occurs. The start argument is required if compare is specified.; string1 - a String expression being searched.; string2 - a String expression searched for.
See Also:: InStr(double start, String string1, String string2, double compare).

InStr

public static int InStr(double start,
                        java.lang.String string1,
                        java.lang.String string2,
                        double compare)
                 throws java.lang.Exception

Returns the position of the first occurrence of one string within another.

Parameters:

start - A numeric expression that sets the starting position for each search. If omitted, search begins at the first character position. If start contains Null, an error occurs. The start argument is required if compare is specified.

string1 - a String expression being searched.

string2 - a String expression searched for.

compare - A numeric value indicating the kind of comparison to use when evaluating substrings.

Returns:

The InStr function returns the following values:

If	InStr returns
string1 is zero-length	0
string1 is Null	-2
string2 is zero-length	start
string2 is Null	-2
string2 is not found	0
string2 is found within string1	Position at which match is found
start > Len(string2)	0

InStrRev

public static int InStrRev(java.lang.String string1,
                           java.lang.String string2)
                    throws java.lang.Exception

Returns the position of an occurrence of one string within another, from the end of string.

Parameters:: string1 - a String expression being searched.; string2 - a String expression being searched for.

InStrRev

public static int InStrRev(java.lang.String string1,
                           java.lang.String string2,
                           double start)
                    throws java.lang.Exception

Returns the position of an occurrence of one string within another, from the end of string.

Parameters:: string1 - a String expression being searched.; string2 - a String expression being searched for.; start - A numeric expression that sets the starting position for each search. If omitted, -1 is used, which means that the search begins at the last character position. If start contains Null, an error occurs.

InStrRev

public static int InStrRev(java.lang.String string1,
                           java.lang.String string2,
                           double start,
                           double compare)
                    throws java.lang.Exception

Returns the position of an occurrence of one string within another, from the end of string.

Parameters:

string1 - a String expression being searched.

string2 - a String expression being searched for.

start - A numeric expression that sets the starting position for each search. If omitted, -1 is used, which means that the search begins at the last character position. If start contains Null, an error occurs.

compare - A numeric value indicating the kind of comparison to use when evaluating substrings. If omitted, a binary comparison is performed.

Returns:

the InStrRev returns the following values:

If	InStrRev returns
string1 is zero-length	0
string1 is Null	-2
string2 is zero-length	start
string2 is Null	-2
string2 is not found	0
string2 is found within string1	Position at which match is found
start > Len(string2)	0

Len

public static int Len(java.lang.String string)
               throws java.lang.Exception

Returns the number of characters in a string.

Parameters:: string - a String.
Returns:: the number of characters in a string. if the string is null, returns -1.

Len

public static int Len(vbdate st)
               throws java.lang.Exception

Returns the number of characters in a string.

Parameters:: st - a vbdate.
Returns:: the number of characters in a string. if the st is null, returns -1.

Len

public static int Len(vbcurrency st)
               throws java.lang.Exception

Returns the number of characters in a string.

Parameters:: st - a vbcurrency.
Returns:: the number of characters in a currency string. if the st is null, returns -1.

Len

public static int Len(variant st)
               throws java.lang.Exception

Returns the number of characters in a string.

Parameters:: st - a variant.
Returns:: the number of characters in a variant. if the st is null, returns -1.

Len

public static int Len(double st)
               throws java.lang.Exception

Returns the number of characters in a string.

Parameters:: st - a double value.
Returns:: the number of characters in a double value.

Len

public static int Len(int st)
               throws java.lang.Exception

Returns the number of characters in a string.

Len

public static int Len(long string)
               throws java.lang.Exception

Returns the number of characters in a string.

Len

public static int Len(boolean st)
               throws java.lang.Exception

Returns the number of characters in a string.

LCase

public static java.lang.String LCase(java.lang.String string)
                              throws java.lang.Exception

Returns a string that has been converted to lowercase.

Parameters:: string - any valid string expression.
Returns:: If string contains Null, Null is returned.

LCase

public static java.lang.String LCase(boolean string)
                              throws java.lang.Exception

Returns a string that has been converted to lowercase.

Parameters:: string - any valid string expression.
Returns:: If string contains Null, Null is returned.

LCase

public static java.lang.String LCase(double string)
                              throws java.lang.Exception

Returns a string that has been converted to lowercase.

Parameters:: string - any valid string expression.
Returns:: If string contains Null, Null is returned.

LCase

public static java.lang.String LCase(variant string)
                              throws java.lang.Exception

Returns a string that has been converted to lowercase.

Parameters:: string - any valid string expression.
Returns:: If string contains Null, Null is returned.

LCase

public static java.lang.String LCase(vbdate string)
                              throws java.lang.Exception

Returns a string that has been converted to lowercase.

Parameters:: string - any valid string expression.
Returns:: If string contains Null, Null is returned.

LCase

public static java.lang.String LCase(vbcurrency string)
                              throws java.lang.Exception

Returns a string that has been converted to lowercase.

Parameters:: string - any valid string expression.
Returns:: If string contains Null, Null is returned.

UCase

public static java.lang.String UCase(java.lang.String string)
                              throws java.lang.Exception

Returns a string that has been converted to uppercase.

Parameters:: string - any valid string expression.
Returns:: If string contains Null, Null is returned.

UCase

public static java.lang.String UCase(boolean string)
                              throws java.lang.Exception

Returns a string that has been converted to uppercase.

Parameters:: string - any valid string expression.
Returns:: If string contains Null, Null is returned.

UCase

public static java.lang.String UCase(double string)
                              throws java.lang.Exception

Returns a string that has been converted to uppercase.

Parameters:: string - any valid string expression.
Returns:: If string contains Null, Null is returned.

UCase

public static java.lang.String UCase(variant string)
                              throws java.lang.Exception

Returns a string that has been converted to uppercase.

Parameters:: string - any valid string expression.
Returns:: If string contains Null, Null is returned.

UCase

public static java.lang.String UCase(vbdate string)
                              throws java.lang.Exception

Returns a string that has been converted to uppercase.

Parameters:: string - any valid string expression.
Returns:: If string contains Null, Null is returned.

UCase

public static java.lang.String UCase(vbcurrency string)
                              throws java.lang.Exception

Returns a string that has been converted to uppercase.

Parameters:: string - any valid string expression.
Returns:: If string contains Null, Null is returned.

Left

public static java.lang.String Left(java.lang.String string,
                                    double length)
                             throws java.lang.Exception

Returns a specified number of characters from the left side of a string.

Parameters:: string - a String expression from which the leftmost characters are returned.; length - A numeric expression indicating how many characters to return.
Returns:: If string contains Null, Null is returned.
if length is 0, a zero-length string("") is returned.
If length is greater than or equal to the number of characters in string, the entire string is returned.

Mid

public static java.lang.String Mid(java.lang.String string,
                                   double start)
                            throws java.lang.Exception

Returns a specified number of characters from a string.

Parameters:: string - a String expression from which characters are returned.; start - the Character position in string at which the part to be taken begins.
Returns:: If string contains Null, Null is returned.
If start is greater than the number of characters in string, Mid returns a zero-length string ("").

Mid

public static java.lang.String Mid(java.lang.String string,
                                   double start,
                                   double length)
                            throws java.lang.Exception

Returns a specified number of characters from a string.

Parameters:: string - a String expression from which characters are returned.; start - the Character position in string at which the part to be taken begins.; length - the Number of characters to return.
Returns:: If string contains Null, Null is returned.
If start is greater than the number of characters in string, Mid returns a zero-length string ("").

Right

public static java.lang.String Right(java.lang.String string,
                                     double length)
                              throws java.lang.Exception

Returns a specified number of characters from the right side of a string.

Parameters:: string - a String expression from which the rightmost characters are returned.; length - A numeric expression indicating how many characters to return.
Returns:: If string contains Null, Null is returned.
If length is 0, a zero-length string is returned.
If length is greater than or equal to the number of characters in string, the entire string is returned.

Replace

public static java.lang.String Replace(java.lang.String expression,
                                       java.lang.String find,
                                       java.lang.String replacewith)
                                throws java.lang.Exception

Returns a string in which a specified substring has been replaced with another substring a specified number of times.

Parameters:: expression - a String expression containing substring to replace.; find - a Substring being searched for.; replacewith - Replacement substring.

Replace

public static java.lang.String Replace(java.lang.String expression,
                                       java.lang.String find,
                                       java.lang.String replacewith,
                                       double start)
                                throws java.lang.Exception

Returns a string in which a specified substring has been replaced with another substring a specified number of times.

Parameters:: expression - a String expression containing substring to replace.; find - a Substring being searched for.; replacewith - Replacement substring.; start - The position within expression where substring search is to begin. If omitted, 1 is assumed. Must be used in conjunction with count.

Replace

public static java.lang.String Replace(java.lang.String expression,
                                       java.lang.String find,
                                       java.lang.String replacewith,
                                       double start,
                                       double count)
                                throws java.lang.Exception

Returns a string in which a specified substring has been replaced with another substring a specified number of times.

Parameters:: expression - a String expression containing substring to replace.; find - a Substring being searched for.; replacewith - Replacement substring.; start - The position within expression where substring search is to begin. If omitted, 1 is assumed. Must be used in conjunction with count.; count - The Number of substring substitutions to perform. If omitted, the default value is -1, which means make all possible substitutions. Must be used in conjunction with start.

Replace

public static java.lang.String Replace(java.lang.String expression,
                                       java.lang.String find,
                                       java.lang.String replacewith,
                                       double start,
                                       double count,
                                       double compare)
                                throws java.lang.Exception

Returns a string in which a specified substring has been replaced with another substring a specified number of times.

Parameters:: expression - a String expression containing substring to replace.; find - a Substring being searched for.; replacewith - Replacement substring.; start - The position within expression where substring search is to begin. If omitted, 1 is assumed. Must be used in conjunction with count.; count - The Number of substring substitutions to perform. If omitted, the default value is -1, which means make all possible substitutions. Must be used in conjunction with start.; compare - The Numeric value indicating the kind of comparison to use when evaluating substrings. See Settings section for values. If omitted, the default value is 0, which means perform a binary comparison.

Space

public static java.lang.String Space(double number)
                              throws java.lang.Exception

Returns a string consisting of the specified number of spaces.

Parameters:: number - the number of spaces you want in the string.

Space

public static java.lang.String Space(java.lang.String number)
                              throws java.lang.Exception

Returns a string consisting of the specified number of spaces.

Parameters:: number - the number of spaces you want in the string.

Space

public static java.lang.String Space(boolean number)
                              throws java.lang.Exception

Returns a string consisting of the specified number of spaces.

Parameters:: number - a boolean value.

Space

public static java.lang.String Space(variant number)
                              throws java.lang.Exception

Returns a string consisting of the specified number of spaces.

Parameters:: number - the number of spaces you want in the string.

Split

public static vbarray Split(java.lang.String expression)
                     throws java.lang.Exception

Returns a zero-based, one-dimensional array containing a specified number of substrings.

Parameters:: expression - a String expression containing substrings and delimiters.
Returns:: If expression is a zero-length string, Split returns an empty array, that is, an array with no elements and no data.

Split

public static vbarray Split(double expression)
                     throws java.lang.Exception

Returns a zero-based, one-dimensional array containing a specified number of substrings.

Split

public static vbarray Split(boolean expression)
                     throws java.lang.Exception

Returns a zero-based, one-dimensional array containing a specified number of substrings.

Split

public static vbarray Split(java.lang.String expression,
                            java.lang.String delimiter)
                     throws java.lang.Exception

Returns a zero-based, one-dimensional array containing a specified number of substrings.

Parameters:: a - String expression containing substrings and delimiters.; delimiter - a String character used to identify substring limits
Returns:: If expression is a zero-length string, Split returns an empty array, that is, an array with no elements and no data
If delimiter is a zero-length string, a single-element array containing the entire expression string is returned

Split

public static vbarray Split(java.lang.String expression,
                            java.lang.String delimiter,
                            double count)
                     throws java.lang.Exception

Returns a zero-based, one-dimensional array containing a specified number of substrings.

Parameters:: a - String expression containing substrings and delimiters.; delimiter - a String character used to identify substring limits; count - a Number of substrings to be returned; -1 indicates that all substrings are returned.
Returns:: If expression is a zero-length string, Split returns an empty array, that is, an array with no elements and no data
If delimiter is a zero-length string, a single-element array containing the entire expression string is returned

Split

public static vbarray Split(java.lang.String expression,
                            java.lang.String delimiter,
                            double count,
                            double compare)
                     throws java.lang.Exception

Returns a zero-based, one-dimensional array containing a specified number of substrings.

Parameters:: a - String expression containing substrings and delimiters.; delimiter - a String character used to identify substring limits; count - a Number of substrings to be returned; -1 indicates that all substrings are returned.; compare - A numeric value indicating the kind of comparison to use when evaluating substrings
Returns:: If expression is a zero-length string, Split returns an empty array, that is, an array with no elements and no data
If delimiter is a zero-length string, a single-element array containing the entire expression string is returned

Filter

public static vbarray Filter(vbarray inputStrings,
                             java.lang.String value)
                      throws java.lang.Exception

Returns a zero-based array containing a subset of a string array based on a specified filter criteria.

Parameters:: inputStrings - One-dimensional array of strings to be searched.; value - a String to search for.

Filter

public static vbarray Filter(vbarray inputStrings,
                             java.lang.String value,
                             boolean include)
                      throws java.lang.Exception

Returns a zero-based array containing a subset of a string array based on a specified filter criteria.

Parameters:: inputStrings - One-dimensional array of strings to be searched.; value - a String to search for.; include - a boolean value indicating whether to return substrings that include or exclude value.

Filter

public static vbarray Filter(vbarray inputStrings,
                             java.lang.String value,
                             boolean include,
                             double compare)
                      throws java.lang.Exception

Returns a zero-based array containing a subset of a string array based on a specified filter criteria.

Parameters:: inputStrings - One-dimensional array of strings to be searched.; value - a String to search for.; include - a boolean value indicating whether to return substrings that include or exclude value.; compare - A numeric value indicating the kind of string comparison to use.

Filter

public static vbarray Filter(variant inputStrings,
                             java.lang.String value)
                      throws java.lang.Exception

Returns a zero-based array containing a subset of a string array based on a specified filter criteria.

Parameters:: inputStrings - One-dimensional array of strings to be searched.; value - a String to search for.

Filter

public static vbarray Filter(variant inputStrings,
                             java.lang.String value,
                             boolean include)
                      throws java.lang.Exception

Returns a zero-based array containing a subset of a string array based on a specified filter criteria.

Parameters:: inputStrings - One-dimensional array of strings to be searched.; value - a String to search for.; include - a boolean value indicating whether to return substrings that include or exclude value.

Filter

public static vbarray Filter(variant inputStrings,
                             java.lang.String value,
                             boolean include,
                             double compare)
                      throws java.lang.Exception

Returns a zero-based array containing a subset of a string array based on a specified filter criteria.

Parameters:: inputStrings - One-dimensional array of strings to be searched.; value - a String to search for.; include - a boolean value indicating whether to return substrings that include or exclude value.; compare - A numeric value indicating the kind of string comparison to use.

StrComp

public static int StrComp(java.lang.String string1,
                          java.lang.String string2)
                   throws java.lang.Exception

Returns a value indicating the result of a string comparison.

Parameters:: string1 - Any valid string expression.; string2 - Any valid string expression.

StrComp

public static int StrComp(java.lang.String string1,
                          java.lang.String string2,
                          double compare)
                   throws java.lang.Exception

Returns a value indicating the result of a string comparison.

Parameters:: string1 - Any valid string expression.; string2 - Any valid string expression.; compare - A numeric value indicating the kind of comparison to use when evaluating strings.

String

public static java.lang.String String(double number,
                                      java.lang.String character)
                               throws java.lang.Exception

Returns a repeating character string of the length specified.

Parameters:: number - Length of the returned string.; character - Character code specifying the character or string expression whose first character is used to build the return string. If character contains Null, Null is returned.

String

public static java.lang.String String(double number,
                                      double character)
                               throws java.lang.Exception

Returns a repeating character string of the length specified.

Parameters:: number - Length of the returned string. If number contains Null, Null is returned.; character - a double value specifying the character to build the return string.

String

public static java.lang.String String(double number,
                                      variant cv)
                               throws java.lang.Exception

Returns a repeating character string of the length specified.

Parameters:: number - Length of the returned string.; cv - Character code specifying the character or string expression whose first character is used to build the return string. If character contains Null, Null is returned.

StrReverse

public static java.lang.String StrReverse(java.lang.String string1)
                                   throws java.lang.Exception

Returns a string in which the character order of a specified string is reversed.

Parameters:: string1 - a String whose characters are to be reversed.
Returns:: If string1 is a zero-length string (""), a zero-length string is returned. If string1 is Null, Null is returned.

StrReverse

public static java.lang.String StrReverse(variant string1)
                                   throws java.lang.Exception

Returns a string in which the character order of a specified string is reversed.

Parameters:: string1 - a String whose characters are to be reversed.
Returns:: If string1 is a zero-length string (""), a zero-length string is returned. If string1 is Null, Null is returned.

StrReverse

public static java.lang.String StrReverse(double string1)
                                   throws java.lang.Exception

Returns a string in which the character order of a specified string is reversed.

StrReverse

public static java.lang.String StrReverse(vbdate string1)
                                   throws java.lang.Exception

Returns a string in which the character order of a specified string is reversed.

StrReverse

public static java.lang.String StrReverse(vbcurrency string1)
                                   throws java.lang.Exception

Returns a string in which the character order of a specified string is reversed.

StrReverse

public static java.lang.String StrReverse(boolean string1)
                                   throws java.lang.Exception

Returns a string in which the character order of a specified string is reversed.

LTrim

public static java.lang.String LTrim(java.lang.String string)
                              throws java.lang.Exception

Returns a copy of a string without leading spaces.

LTrim

public static java.lang.String LTrim(variant string)
                              throws java.lang.Exception

Returns a copy of a string without leading spaces.

LTrim

public static java.lang.String LTrim(double string)
                              throws java.lang.Exception

Returns a copy of a string without leading spaces.

LTrim

public static java.lang.String LTrim(vbdate string)
                              throws java.lang.Exception

Returns a copy of a string without leading spaces.

LTrim

public static java.lang.String LTrim(vbcurrency string)
                              throws java.lang.Exception

Returns a copy of a string without leading spaces.

LTrim

public static java.lang.String LTrim(boolean string)
                              throws java.lang.Exception

Returns a copy of a string without leading spaces.

RTrim

public static java.lang.String RTrim(java.lang.String string)
                              throws java.lang.Exception

Returns a copy of a string without trailing spaces.

RTrim

public static java.lang.String RTrim(double string)
                              throws java.lang.Exception

Returns a copy of a string without trailing spaces.

RTrim

public static java.lang.String RTrim(variant string)
                              throws java.lang.Exception

Returns a copy of a string without trailing spaces.

RTrim

public static java.lang.String RTrim(vbdate string)
                              throws java.lang.Exception

Returns a copy of a string without trailing spaces.

RTrim

public static java.lang.String RTrim(vbcurrency string)
                              throws java.lang.Exception

Returns a copy of a string without trailing spaces.

RTrim

public static java.lang.String RTrim(boolean string)
                              throws java.lang.Exception

Returns a copy of a string without trailing spaces.

Trim

public static java.lang.String Trim(java.lang.String string)
                             throws java.lang.Exception

Returns a copy of a string without both leading and trailing spaces.

Trim

public static java.lang.String Trim(variant string)
                             throws java.lang.Exception

Returns a copy of a string without both leading and trailing spaces.

Trim

public static java.lang.String Trim(vbdate string)
                             throws java.lang.Exception

Returns a copy of a string without both leading and trailing spaces.

Trim

public static java.lang.String Trim(vbcurrency string)
                             throws java.lang.Exception

Returns a copy of a string without both leading and trailing spaces.

Trim

public static java.lang.String Trim(double string)
                             throws java.lang.Exception

Returns a copy of a string without both leading and trailing spaces.

Trim

public static java.lang.String Trim(boolean string)
                             throws java.lang.Exception

Returns a copy of a string without both leading and trailing spaces.

Cos

public static double Cos(double number)
                  throws java.lang.Exception

Returns the cosine of an angle.

Cos

public static double Cos(java.lang.String number)
                  throws java.lang.Exception

Returns the cosine of an angle.

Cos

public static double Cos(boolean number)
                  throws java.lang.Exception

Returns the cosine of an angle.

Cos

public static double Cos(variant number)
                  throws java.lang.Exception

Returns the cosine of an angle.

Cos

public static double Cos(vbdate number)
                  throws java.lang.Exception

Returns the cosine of an angle.

Cos

public static double Cos(vbcurrency number)
                  throws java.lang.Exception

Returns the cosine of an angle.

Sin

public static double Sin(double number)
                  throws java.lang.Exception

Returns the sine of an angle.

Sin

public static double Sin(java.lang.String number)
                  throws java.lang.Exception

Returns the sine of an angle.

Sin

public static double Sin(boolean number)
                  throws java.lang.Exception

Returns the sine of an angle.

Sin

public static double Sin(vbdate number)
                  throws java.lang.Exception

Returns the sine of an angle.

Sin

public static double Sin(vbcurrency number)
                  throws java.lang.Exception

Returns the sine of an angle.

Sin

public static double Sin(variant number)
                  throws java.lang.Exception

Returns the sine of an angle.

Tan

public static double Tan(double number)
                  throws java.lang.Exception

Returns the tangent of an angle.

Tan

public static double Tan(java.lang.String number)
                  throws java.lang.Exception

Returns the tangent of an angle.

Tan

public static double Tan(boolean number)
                  throws java.lang.Exception

Returns the tangent of an angle.

Tan

public static double Tan(variant number)
                  throws java.lang.Exception

Returns the tangent of an angle.

Tan

public static double Tan(vbdate number)
                  throws java.lang.Exception

Returns the tangent of an angle.

Tan

public static double Tan(vbcurrency number)
                  throws java.lang.Exception

Returns the tangent of an angle.

Exp

public static double Exp(double number)
                  throws java.lang.Exception

Returns e (the base of natural logarithms) raised to a power.

Exp

public static double Exp(java.lang.String number)
                  throws java.lang.Exception

Returns e (the base of natural logarithms) raised to a power.

Exp

public static double Exp(boolean number)
                  throws java.lang.Exception

Returns e (the base of natural logarithms) raised to a power.

Exp

public static double Exp(variant number)
                  throws java.lang.Exception

Returns e (the base of natural logarithms) raised to a power.

Exp

public static double Exp(vbdate number)
                  throws java.lang.Exception

Returns e (the base of natural logarithms) raised to a power.

Exp

public static double Exp(vbcurrency number)
                  throws java.lang.Exception

Returns e (the base of natural logarithms) raised to a power.

Log

public static double Log(double number)
                  throws java.lang.Exception

Returns the natural logarithm of a number.

Log

public static double Log(java.lang.String number)
                  throws java.lang.Exception

Log

public static double Log(boolean number)
                  throws java.lang.Exception

Returns the natural logarithm of a number.

Log

public static double Log(variant number)
                  throws java.lang.Exception

Returns the natural logarithm of a number.

Log

public static double Log(vbdate number)
                  throws java.lang.Exception

Returns the natural logarithm of a number.

Log

public static double Log(vbcurrency number)
                  throws java.lang.Exception

Returns the natural logarithm of a number.

Sqr

public static double Sqr(double number)
                  throws java.lang.Exception

Returns the square root of a number.

Sqr

public static double Sqr(java.lang.String number)
                  throws java.lang.Exception

Returns the square root of a number.

Sqr

public static double Sqr(boolean number)
                  throws java.lang.Exception

Returns the square root of a number.

Sqr

public static double Sqr(variant number)
                  throws java.lang.Exception

Returns the square root of a number.

Sqr

public static double Sqr(vbdate number)
                  throws java.lang.Exception

Returns the square root of a number.

Sqr

public static double Sqr(vbcurrency number)
                  throws java.lang.Exception

Returns the square root of a number.

Rnd

public static double Rnd()
                  throws java.lang.Exception

Returns a random number.

Rnd

public static double Rnd(double number)
                  throws java.lang.Exception

Returns a random number.

Round

public static double Round(double expression)
                    throws java.lang.Exception

Returns a number rounded to a specified number of decimal places.

Round

public static vbdate Round(vbdate expression)
                    throws java.lang.Exception

Returns a number rounded to a specified number of decimal places.

Round

public static vbcurrency Round(vbcurrency expression)
                        throws java.lang.Exception

Returns a number rounded to a specified number of decimal places.

Round

public static vbdate Round(vbdate expression,
                           double numdecimalplaces)
                    throws java.lang.Exception

Returns a number rounded to a specified number of decimal places.

Round

public static vbcurrency Round(vbcurrency expression,
                               double numdecimalplaces)
                        throws java.lang.Exception

Returns a number rounded to a specified number of decimal places.

Round

public static double Round(java.lang.String expression)
                    throws java.lang.Exception

Returns a number rounded to a specified number of decimal places.

Round

public static double Round(variant expression)
                    throws java.lang.Exception

Returns a number rounded to a specified number of decimal places.

Round

public static boolean Round(boolean expression)
                     throws java.lang.Exception

Returns a number rounded to a specified number of decimal places.

Round

public static double Round(double expression,
                           double numdecimalplaces)
                    throws java.lang.Exception

Returns a number rounded to a specified number of decimal places.

FormatCurrency

public static java.lang.String FormatCurrency(variant expression)
                                       throws java.lang.Exception

Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.

FormatCurrency

public static java.lang.String FormatCurrency(double expression)
                                       throws java.lang.Exception

Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.

Parameters:: Expression - An expression to be formatted.

FormatCurrency

public static java.lang.String FormatCurrency(double expression,
                                              double NumDigitsAfterDecimal)
                                       throws java.lang.Exception

Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.

Parameters:: Expression - An expression to be formatted.; NumDigitsAfterDecimal - A numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the computer's regional settings are used.

FormatCurrency

public static java.lang.String FormatCurrency(double expression,
                                              double NumDigitsAfterDecimal,
                                              double IncludeLeadingDigit)
                                       throws java.lang.Exception

Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.

Parameters:: Expression - An expression to be formatted.; NumDigitsAfterDecimal - A numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the computer's regional settings are used.; IncludeLeadingDigit - Tristate constant that indicates whether or not a leading zero is displayed for fractional values. See Settings section for values.

FormatCurrency

public static java.lang.String FormatCurrency(double expression,
                                              double NumDigitsAfterDecimal,
                                              double IncludeLeadingDigit,
                                              double UseParensForNegativeNumbers)
                                       throws java.lang.Exception

Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.

Parameters:: Expression - An expression to be formatted.; NumDigitsAfterDecimal - A numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the computer's regional settings are used.; IncludeLeadingDigit - Tristate constant that indicates whether or not a leading zero is displayed for fractional values. See Settings section for values.; UseParensForNegativeNumbers - Tristate constant that indicates whether or not to place negative values within parentheses. See Settings section for values.

FormatCurrency

public static java.lang.String FormatCurrency(double expression,
                                              double NumDigitsAfterDecimal,
                                              double IncludeLeadingDigit,
                                              double UseParensForNegativeNumbers,
                                              double GroupDigits)
                                       throws java.lang.Exception

Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.

Parameters:: Expression - An expression to be formatted.; NumDigitsAfterDecimal - A numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the computer's regional settings are used.; IncludeLeadingDigit - Tristate constant that indicates whether or not a leading zero is displayed for fractional values. See Settings section for values.; UseParensForNegativeNumbers - Tristate constant that indicates whether or not to place negative values within parentheses. See Settings section for values.; GroupDigits - Tristate constant that indicates whether or not numbers are grouped using the group delimiter specified in the computer's regional settings. See Settings section for values.

FormatNumber

public static java.lang.String FormatNumber(variant expression)
                                     throws java.lang.Exception

Returns an expression formatted as a number.

Parameters:: Expression - An expression to be formatted.

FormatNumber

public static java.lang.String FormatNumber(double expression)
                                     throws java.lang.Exception

Returns an expression formatted as a number.

Parameters:: Expression - An expression to be formatted.

FormatNumber

public static java.lang.String FormatNumber(double expression,
                                            double NumDigitsAfterDecimal)
                                     throws java.lang.Exception

Returns an expression formatted as a number.

Parameters:: Expression - An expression to be formatted.; NumDigitsAfterDecimal - A numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the computer's regional settings are used.

FormatNumber

public static java.lang.String FormatNumber(double expression,
                                            double NumDigitsAfterDecimal,
                                            double IncludeLeadingDigit)
                                     throws java.lang.Exception

Returns an expression formatted as a number.

Parameters:: Expression - An expression to be formatted.; NumDigitsAfterDecimal - A numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the computer's regional settings are used.; IncludeLeadingDigit - Tristate constant that indicates whether or not a leading zero is displayed for fractional values. See Settings section for values.

FormatNumber

public static java.lang.String FormatNumber(double expression,
                                            double NumDigitsAfterDecimal,
                                            double IncludeLeadingDigit,
                                            double UseParensForNegativeNumbers)
                                     throws java.lang.Exception

Returns an expression formatted as a number.

Parameters:: Expression - An expression to be formatted.; NumDigitsAfterDecimal - A numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the computer's regional settings are used.; IncludeLeadingDigit - Tristate constant that indicates whether or not a leading zero is displayed for fractional values. See Settings section for values.; UseParensForNegativeNumbers - Tristate constant that indicates whether or not to place negative values within parentheses. See Settings section for values.

FormatNumber

public static java.lang.String FormatNumber(double expression,
                                            double NumDigitsAfterDecimal,
                                            double IncludeLeadingDigit,
                                            double UseParensForNegativeNumbers,
                                            double GroupDigits)
                                     throws java.lang.Exception

Returns an expression formatted as a number.

Parameters:: Expression - An expression to be formatted.; NumDigitsAfterDecimal - A numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the computer's regional settings are used.; IncludeLeadingDigit - Tristate constant that indicates whether or not a leading zero is displayed for fractional values. See Settings section for values.; UseParensForNegativeNumbers - Tristate constant that indicates whether or not to place negative values within parentheses. See Settings section for values.; GroupDigits - Tristate constant that indicates whether or not numbers are grouped using the group delimiter specified in the control panel. See Settings section for values.

FormatPercent

public static java.lang.String FormatPercent(variant expression)
                                      throws java.lang.Exception

Returns an expression formatted as a percentage (multiplied by 100) with a trailing % character.

Parameters:: expression - An expression to be formatted.

FormatPercent

public static java.lang.String FormatPercent(double expression)
                                      throws java.lang.Exception

Returns an expression formatted as a percentage (multiplied by 100) with a trailing % character.

Parameters:: expression - An expression to be formatted.

FormatPercent

public static java.lang.String FormatPercent(double expression,
                                             double NumDigitsAfterDecimal)
                                      throws java.lang.Exception

Returns an expression formatted as a percentage (multiplied by 100) with a trailing % character.

Parameters:: expression - An expression to be formatted.; NumDigitsAfterDecimal - A numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the computer's regional settings are used.

FormatPercent

public static java.lang.String FormatPercent(double expression,
                                             double NumDigitsAfterDecimal,
                                             double IncludeLeadingDigit)
                                      throws java.lang.Exception

Returns an expression formatted as a percentage (multiplied by 100) with a trailing % character.

Parameters:: expression - An expression to be formatted.; NumDigitsAfterDecimal - A numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the computer's regional settings are used.; IncludeLeadingDigit - Tristate constant that indicates whether or not a leading zero is displayed for fractional values. See Settings section for values.

FormatPercent

public static java.lang.String FormatPercent(double expression,
                                             double NumDigitsAfterDecimal,
                                             double IncludeLeadingDigit,
                                             double UseParensForNegativeNumbers)
                                      throws java.lang.Exception

Returns an expression formatted as a percentage (multiplied by 100) with a trailing % character.

Parameters:: expression - An expression to be formatted.; NumDigitsAfterDecimal - A numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the computer's regional settings are used.; IncludeLeadingDigit - Tristate constant that indicates whether or not a leading zero is displayed for fractional values. See Settings section for values.; UseParensForNegativeNumbers - Tristate constant that indicates whether or not to place negative values within parentheses. See Settings section for values.

FormatPercent

public static java.lang.String FormatPercent(double expression,
                                             double NumDigitsAfterDecimal,
                                             double IncludeLeadingDigit,
                                             double UseParensForNegativeNumbers,
                                             double GroupDigits)
                                      throws java.lang.Exception

Returns an expression formatted as a percentage (multiplied by 100) with a trailing % character.

Parameters:: Expression - An expression to be formatted.; NumDigitsAfterDecimal - A numeric value indicating how many places to the right of the decimal are displayed. Default value is -1, which indicates that the computer's regional settings are used.; IncludeLeadingDigit - Tristate constant that indicates whether or not a leading zero is displayed for fractional values. See Settings section for values.; UseParensForNegativeNumbers - Tristate constant that indicates whether or not to place negative values within parentheses. See Settings section for values.; GroupDigits - Tristate constant that indicates whether or not numbers are grouped using the group delimiter specified in the control panel. See Settings section for values.

FormatDateTime

public static java.lang.String FormatDateTime(double date)
                                       throws java.lang.Exception

Returns an expression formatted as a date or time.

FormatDateTime

public static java.lang.String FormatDateTime(double date,
                                              double NamedFormat)
                                       throws java.lang.Exception

Returns an expression formatted as a date or time.

FormatDateTime

public static java.lang.String FormatDateTime(java.lang.String date)
                                       throws java.lang.Exception

Returns an expression formatted as a date or time.

Parameters:: date - A date expression to be formatted.

FormatDateTime

public static java.lang.String FormatDateTime(java.lang.String date,
                                              double NamedFormat)
                                       throws java.lang.Exception

Returns an expression formatted as a date or time.

Parameters:: date - A date expression to be formatted.; NamedFormat - a numeric value that indicates the date/time format used. If omitted, vbGeneralDate is used.

FormatDateTime

public static java.lang.String FormatDateTime(vbdate date)
                                       throws java.lang.Exception

Returns an expression formatted as a date or time.

Parameters:: date - A date expression to be formatted.

FormatDateTime

public static java.lang.String FormatDateTime(vbdate date,
                                              double NamedFormat)
                                       throws java.lang.Exception

Returns an expression formatted as a date or time.

Parameters:: date - A date expression to be formatted.; NamedFormat - A numeric value that indicates the date/time format used. If omitted, vbGeneralDate is used.

FormatDateTime

public static java.lang.String FormatDateTime(variant date)
                                       throws java.lang.Exception

Returns an expression formatted as a date or time.

Parameters:: date - A date expression to be formatted.

FormatDateTime

public static java.lang.String FormatDateTime(variant date,
                                              double NamedFormat)
                                       throws java.lang.Exception

Returns an expression formatted as a date or time.

Parameters:: date - A date expression to be formatted.; NamedFormat - A numeric value that indicates the date/time format used. If omitted, vbGeneralDate is used.

IsArray

public static boolean IsArray(variant obj)

Returns a Boolean value indicating whether a variable is an array.

IsArray

public static boolean IsArray(vbarray obj)

Returns a Boolean value indicating whether a variable is an array.

LBound

public static int LBound(variant arrayname)
                  throws java.lang.Exception

Returns the smallest available subscript for the indicated dimension of an array.

Parameters:: arrayname - name of the array variable.
Returns:: 0.

LBound

public static int LBound(vbarray arrayname)
                  throws java.lang.Exception

Returns the smallest available subscript for the indicated dimension of an array.

Parameters:: arrayname - name of the array variable.
Returns:: 0.

LBound

public static int LBound(java.lang.Object arrayname,
                         double dimension)
                  throws java.lang.Exception

Returns the smallest available subscript for the indicated dimension of an array.

Parameters:: arrayname - name of the array variable.; dimension - whole number indicating which dimension's lower bound is returned.
Returns:: 0.

LBound

public static int LBound(vbarray arrayname,
                         double dimension)
                  throws java.lang.Exception

Returns the smallest available subscript for the indicated dimension of an array.

Parameters:: arrayname - name of the array variable.; dimension - whole number indicating which dimension's lower bound is returned.
Returns:: 0.

LBound

public static int LBound(variant arrayname,
                         double dimension)
                  throws java.lang.Exception

Returns the smallest available subscript for the indicated dimension of an array.

Parameters:: arrayname - name of the array variable.; dimension - whole number indicating which dimension's lower bound is returned.
Returns:: 0.

UBound

public static int UBound(variant array)
                  throws java.lang.Exception

Returns the largest available subscript for the indicated dimension of an array.

Parameters:: array - the name of the array variable.

UBound

public static int UBound(vbarray array)
                  throws java.lang.Exception

Returns the largest available subscript for the indicated dimension of an array.

Parameters:: array - the name of the array variable.

UBound

public static int UBound(java.lang.Object array)
                  throws java.lang.Exception

Returns the largest available subscript for the indicated dimension of an array.

Parameters:: array - the name of the array variable.

UBound

public static int UBound(java.lang.Object array,
                         int dimension)
                  throws java.lang.Exception

Returns the largest available subscript for the indicated dimension of an array.

Parameters:: array - the name of the array variable.; dimension - Whole number indicating which dimension's upper bound is returned. Use 1 for the first dimension, 2 for the second, and so on. If dimension is omitted, 1 is assumed.

UBound

public static int UBound(variant array,
                         int dimension)
                  throws java.lang.Exception

Returns the largest available subscript for the indicated dimension of an array.

Parameters:: array - the name of the array variable.; dimension - Whole number indicating which dimension's upper bound is returned. Use 1 for the first dimension, 2 for the second, and so on. If dimension is omitted, 1 is assumed.

UBound

public static int UBound(vbarray array,
                         int dimension)
                  throws java.lang.Exception

Returns the largest available subscript for the indicated dimension of an array.

Parameters:: array - the name of the array variable.; dimension - Whole number indicating which dimension's upper bound is returned. Use 1 for the first dimension, 2 for the second, and so on. If dimension is omitted, 1 is assumed.

Eval

public static java.lang.String Eval(java.lang.String str)
                             throws java.lang.Exception

Evaluates an expression and returns the result.
Don't support this function.

RGB

public static int RGB(double red,
                      double green,
                      double blue)
               throws java.lang.Exception

Returns a whole number representing an RGB color value.

Parameters:: red - number in the range 0-255 representing the red component of the color.; green - number in the range 0-255 representing the green component of the color.; blue - number in the range 0-255 representing the blue component of the color.
Returns:: the value.

IsDate

public static boolean IsDate(double d)

Returns a Boolean value indicating whether an expression can be converted to a date.

IsDate

public static boolean IsDate(vbdate d)

Returns a Boolean value indicating whether an expression can be converted to a date.

IsDate

public static boolean IsDate(java.lang.String d)

Returns a Boolean value indicating whether an expression can be converted to a date.

IsDate

public static boolean IsDate(variant d)

Returns a Boolean value indicating whether an expression can be converted to a date.

IsEmpty

public static boolean IsEmpty(double d)
                       throws java.lang.Exception

Returns a boolean value indicating whether a variable has been initialized.

IsEmpty

public static boolean IsEmpty(variant d)
                       throws java.lang.Exception

Returns a boolean value indicating whether a variable has been initialized.

IsEmpty

public static boolean IsEmpty(java.lang.String d)
                       throws java.lang.Exception

Returns a boolean value indicating whether a variable has been initialized.

IsEmpty

public static boolean IsEmpty(boolean d)
                       throws java.lang.Exception

Returns a boolean value indicating whether a variable has been initialized.

IsEmpty

public static boolean IsEmpty(vbdate d)
                       throws java.lang.Exception

Returns a boolean value indicating whether a variable has been initialized.

IsNull

public static boolean IsNull(double expression)
                      throws java.lang.Exception

Returns a boolean value that indicates whether An expression contains no valid data ( Null).

IsNull

public static boolean IsNull(java.lang.Object expression)
                      throws java.lang.Exception

Returns a boolean value that indicates whether An expression contains no valid data ( Null).

IsNull

public static boolean IsNull(java.lang.String expression)
                      throws java.lang.Exception

Returns a boolean value that indicates whether An expression contains no valid data ( Null).

IsNull

public static boolean IsNull(vbdate expression)
                      throws java.lang.Exception

Returns a boolean value that indicates whether An expression contains no valid data ( Null).

IsNull

public static boolean IsNull(variant expression)
                      throws java.lang.Exception

Returns a boolean value that indicates whether An expression contains no valid data ( Null).

IsNumeric

public static boolean IsNumeric(double expression)
                         throws java.lang.Exception

Returns a boolean value indicating whether An expression can be evaluated as a number.

IsNumeric

public static boolean IsNumeric(java.lang.String expression)
                         throws java.lang.Exception

Returns a boolean value indicating whether An expression can be evaluated as a number.

IsNumeric

public static boolean IsNumeric(vbdate expression)
                         throws java.lang.Exception

Returns a boolean value indicating whether An expression can be evaluated as a number.

IsNumeric

public static boolean IsNumeric(vbcurrency expression)
                         throws java.lang.Exception

Returns a boolean value indicating whether An expression can be evaluated as a number.

IsNumeric

public static boolean IsNumeric(variant expression)
                         throws java.lang.Exception

Returns a boolean value indicating whether An expression can be evaluated as a number.

IsObject

public static boolean IsObject(variant obj)

Returns a Boolean value indicating whether an expression references a valid Java object.

IsObject

public static boolean IsObject(double obj)

Returns a Boolean value indicating whether an expression references a valid Java object.

IsObject

public static boolean IsObject(java.lang.String obj)

Returns a Boolean value indicating whether an expression references a valid Java object.

IsObject

public static boolean IsObject(boolean b)

Returns a Boolean value indicating whether an expression references a valid Java object.

IsObject

public static boolean IsObject(vbdate b)

Returns a Boolean value indicating whether an expression references a valid Java object.

IsObject

public static boolean IsObject(java.lang.Object b)

Returns a Boolean value indicating whether an expression references a valid Java object.

TypeName

public static java.lang.String TypeName(java.lang.Object obj)

Returns a string that provides Variant subtype information about a variable.

TypeName

public static java.lang.String TypeName(int obj)

Returns a string that provides Variant subtype information about a variable.

TypeName

public static java.lang.String TypeName(variant obj)

Returns a string that provides Variant subtype information about a variable.

TypeName

public static java.lang.String TypeName(short obj)

Returns a string that provides Variant subtype information about a variable.

TypeName

public static java.lang.String TypeName(vbdate obj)

Returns a string that provides Variant subtype information about a variable.

TypeName

public static java.lang.String TypeName(float obj)

Returns a string that provides Variant subtype information about a variable.

TypeName

public static java.lang.String TypeName(boolean obj)

Returns a string that provides Variant subtype information about a variable.

TypeName

public static java.lang.String TypeName(double obj)

Returns a string that provides Variant subtype information about a variable.

TypeName

public static java.lang.String TypeName(java.lang.String obj)

Returns a string that provides Variant subtype information about a variable.

TypeName

public static java.lang.String TypeName(vbcurrency obj)

Returns a string that provides Variant subtype information about a variable.

VarType

public static int VarType(java.lang.Object obj)

Returns a value indicating the subtype of a variable.

Returns:

The VarType function returns the following values:

Constant	Value	Description
vbEmpty	0	Empty (uninitialized)
vbNull	1	Null (no valid data)
vbInteger	2	Integer
vbLong	3	Long integer
vbSingle	4	Single-precision floating-point number
vbDouble	5	Double-precision floating-point number
vbCurrency	6	Currency
vbDate	7	Date
vbString	8	String
vbObject	9	Automation object
Error	10	Error
vbBoolean	11	Boolean
vbVariant	12	Variant (used only with arrays of Variants)
vbDataObject	13	A data-access object
vbByte	17	Byte
vbArray	8192	Array

VarType

public static int VarType(variant obj)

Returns a value indicating the subtype of a variable.

VarType

public static int VarType(byte obj)

Returns a value indicating the subtype of a variable.

VarType

public static int VarType(boolean obj)

Returns a value indicating the subtype of a variable.

VarType

public static int VarType(vbdate obj)

Returns a value indicating the subtype of a variable.

VarType

public static int VarType(vbcurrency obj)

Returns a value indicating the subtype of a variable.

VarType

public static int VarType(short obj)

Returns a value indicating the subtype of a variable.

VarType

public static int VarType(int obj)

Returns a value indicating the subtype of a variable.

VarType

public static int VarType(float obj)

Returns a value indicating the subtype of a variable.

VarType

public static int VarType(double obj)

Returns a value indicating the subtype of a variable.

VarType

public static int VarType(java.lang.String obj)

Returns a value indicating the subtype of a variable.

Date

public static vbdate Date()
                   throws java.lang.Exception

Returns the current system date.

Time

public static vbdate Time()
                   throws java.lang.Exception

Returns a vbdate indicating the current system time.

Timer

public static double Timer()
                    throws java.lang.Exception

Returns the number of seconds that have elapsed since 12:00 AM (midnight).

Now

public static vbdate Now()
                  throws java.lang.Exception

Returns the current date and time according to the setting of your computer's system date and time.

DateAdd

public static vbdate DateAdd(java.lang.String interval,
                             double number,
                             vbdate date)
                      throws java.lang.Exception

Returns a date to which a specified time interval has been added.

Parameters:: interval - a String expression that is the interval you want to add.; number - a numeric expression that is the number of interval you want to add. The numeric expression can either be positive, for dates in the future, or negative, for dates in the past.; date - a vbdate representing the date to which interval is added.

DateDiff

public static double DateDiff(java.lang.String interval,
                              vbdate date1,
                              vbdate date2)
                       throws java.lang.Exception

Returns the number of intervals between two dates.

Parameters:: interval - a String expression that is the interval you want to use to calculate the differences between date1 and date2. See Settings section for values.; date1, - date2 date expressions. Two dates you want to use in the calculation.

DateDiff

public static double DateDiff(java.lang.String interval,
                              vbdate date1,
                              vbdate date2,
                              double firstdayofweek)
                       throws java.lang.Exception

Returns the number of intervals between two dates.

Parameters:: interval - a String expression that is the interval you want to use to calculate the differences between date1 and date2. See Settings section for values.; date1, - date2 date expressions. Two dates you want to use in the calculation.; firstdayofweek - Constant that specifies the day of the week. If not specified, Sunday is assumed.

DateDiff

public static double DateDiff(java.lang.String interval,
                              vbdate date1,
                              vbdate date2,
                              double firstdayofweek,
                              double firstweekofyear)
                       throws java.lang.Exception

Returns the number of intervals between two dates.

Parameters:: interval - a String expression that is the interval you want to use to calculate the differences between date1 and date2. See Settings section for values.; date1, - date2 date expressions. Two dates you want to use in the calculation.; firstdayofweek - Constant that specifies the day of the week. If not specified, Sunday is assumed.; firstweekofyear - Constant that specifies the first week of the year. If not specified, the first week is assumed to be the week in which January 1 occurs.

DatePart

public static int DatePart(java.lang.String interval,
                           vbdate date)
                    throws java.lang.Exception

Returns the specified part of a given date.

Parameters:: interval - String expression that is the interval of time you want to return. See Settings section for values.; date - Date expression you want to evaluate.

DatePart

public static int DatePart(java.lang.String interval,
                           vbdate date,
                           double firstdayofweek)
                    throws java.lang.Exception

Returns the specified part of a given date.

Parameters:: interval - String expression that is the interval of time you want to return. See Settings section for values.; date - Date expression you want to evaluate.; firstdayofweek - Constant that specifies the day of the week. If not specified, Sunday is assumed.

DatePart

public static int DatePart(java.lang.String interval,
                           vbdate date,
                           double firstdayofweek,
                           double firstweekofyear)
                    throws java.lang.Exception

Returns the specified part of a given date.

Parameters:: interval - String expression that is the interval of time you want to return. See Settings section for values.; date - Date expression you want to evaluate.; firstdayofweek - Constant that specifies the day of the week. If not specified, Sunday is assumed.; firstweekofyear - Constant that specifies the first week of the year. If not specified, the first week is assumed to be the week in which January 1 occurs.

DateSerial

public static vbdate DateSerial(double year,
                                double month,
                                double day)
                         throws java.lang.Exception

Returns a vbdate for a specified year, month, and day.

DateValue

public static vbdate DateValue(java.lang.String date)
                        throws java.lang.Exception

Returns a vbdate.

Parameters:: date - Normally a string expression representing a date from January 1, 100 through December 31, 9999. However, date can also be any expression that can represent a date, a time, or both a date and time, in that range.

DateValue

public static vbdate DateValue(vbdate date)
                        throws java.lang.Exception

Returns a vbdate.

DateValue

public static vbdate DateValue(double date)
                        throws java.lang.Exception

Returns a vbdate.

DateValue

public static vbdate DateValue(variant date)
                        throws java.lang.Exception

Returns a vbdate.

Day

public static int Day(vbdate date)
               throws java.lang.Exception

Returns a whole number between 1 and 31, inclusive, representing the day of the month.

Day

public static int Day(java.lang.String date)
               throws java.lang.Exception

Returns a whole number between 1 and 31, inclusive, representing the day of the month.

Day

public static int Day(double date)
               throws java.lang.Exception

Returns a whole number between 1 and 31, inclusive, representing the day of the month.

Day

public static int Day(variant date)
               throws java.lang.Exception

Returns a whole number between 1 and 31, inclusive, representing the day of the month.

Month

public static int Month(vbdate date)
                 throws java.lang.Exception

Returns a whole number between 1 and 12, inclusive, representing the month of the year.

Month

public static int Month(variant date)
                 throws java.lang.Exception

Returns a whole number between 1 and 12, inclusive, representing the month of the year.

Month

public static int Month(double date)
                 throws java.lang.Exception

Returns a whole number between 1 and 12, inclusive, representing the month of the year.

Month

public static int Month(java.lang.String date)
                 throws java.lang.Exception

Returns a whole number between 1 and 12, inclusive, representing the month of the year.

MonthName

public static java.lang.String MonthName(double month)
                                  throws java.lang.Exception

Returns a string indicating the specified month.

MonthName

public static java.lang.String MonthName(boolean month)
                                  throws java.lang.Exception

Returns a string indicating the specified month.

MonthName

public static java.lang.String MonthName(double month,
                                         boolean abbreviate)
                                  throws java.lang.Exception

Returns a string indicating the specified month.

Weekday

public static int Weekday(vbdate date,
                          double firstdayofweek)
                   throws java.lang.Exception

Returns a string indicating the specified month.

MonthName

public static java.lang.String MonthName(boolean month,
                                         boolean abbreviate)
                                  throws java.lang.Exception

Returns a string indicating the specified month.