See: Description
Interface | Description |
---|---|
EvalConfig |
The EvalConfig allows for customization of the expression evaluation
context for a given
Database instance. |
EvalContext |
EvalContext encapsulates all shared state for expression parsing and
evaluation.
|
Expression |
An Expression is an executable handle to an Access expression.
|
Function |
A Function provides an invokable handle to external functionality to an
expression.
|
FunctionLookup |
A FunctionLookup provides a source for
Function instances used
during expression evaluation. |
Value |
Wrapper for a typed primitive value used within the expression evaluation
engine.
|
Class | Description |
---|---|
Identifier |
identifies a database entity (e.g.
|
TemporalConfig |
A TemporalConfig encapsulates date/time formatting options for expression
evaluation.
|
Enum | Description |
---|---|
Value.Type |
the types supported within the expression evaluation engine
|
Exception | Description |
---|---|
EvalException |
Base class for exceptions thrown during expression evaluation.
|
ParseException |
Exception thrown when expression parsing fails.
|
Database.setEvaluateExpressions(Boolean)
.
The expression evaluation engine implementation does its best to follow all
the warts and idiosyncracies of Access expression evaluation (both those
that are documented as well as those discovered through experimentation).
These include such things as value conversions, "Null" handling, rounding
rules, and implicit interpretations of expression in certain contexts.
Expressions can be used in a number of different places within an Access
database. When enabled, Jackcess supports the following usage:
null
value for a field which has a default value
expression defined, that expression will be evaluated and the
result will be inserted for that field. Like an auto-generated
id, the generated default value will be returned in the input
row array.EvalConfig
allows for customization of the expression
evaluation context for a given Database
instance.TemporalConfig
encapsulates date/time formatting options for
expression evaluation.FunctionLookup
provides a source for Function
instances
used during expression evaluation.EvalException
wrapper exception thrown for failures which occur
during expression evaluation.ParseException
wrapper exception thrown for failures which
occur during expression parsing.EvalContext
encapsulates all shared state for expression
parsing and evaluation.Expression
provides an executable handle to an actual
Access expression.Function
provides an invokable handle to external functionality
to an expression.Identifier
identifies a database entity (e.g. the name of a
database field).Value
represents a typed primitive value.Function | Supported |
---|---|
Asc | Y |
AscW | Y |
Chr | Y |
ChrW | Y |
EuroConvert | |
FormatCurrency | |
FormatDateTime | |
FormatNumber | |
FormatPercent | |
GUIDFromString | |
Hex[$] | Y |
Nz | Y |
Oct[$] | Y |
Str[$] | Y |
StringFromGUID | |
Val | |
CBool | Y |
CByte | Y |
CCur | Y |
CDate | Y |
CVDate | Y |
CDbl | Y |
CDec | Y |
CInt | Y |
CLng | Y |
CSng | Y |
CStr | Y |
CVar | Y |
Function | Supported |
---|---|
Day | Y |
Date | Y |
DateAdd | |
DateDiff | |
DatePart | |
DateSerial | Y |
DateValue | Y |
Hour | Y |
Minute | Y |
Month | Y |
MonthName | |
Now | Y |
Second | Y |
Time | Y |
Timer | Y |
TimeSerial | Y |
TimeValue | Y |
Weekday | Y |
WeekdayName | |
Year | Y |
Function | Supported |
---|---|
DDB | |
FV | Y |
IPmt | |
IRR | |
MIRR | |
NPer | Y |
NPV | |
Pmt | Y |
PPmt | |
PV | Y |
Rate | |
SLN | |
SYD |
Function | Supported |
---|---|
IsDate | Partial |
IsEmpty | |
IsError | |
IsMissing | |
IsNull | Y |
IsNumeric | |
IsObject | |
TypeName | Y |
VarType | Y |
Function | Supported |
---|---|
Abs | Y |
Atn | Y |
Cos | Y |
Exp | Y |
Int | Y |
Fix | Y |
Log | Y |
Rnd | Y |
Round | Y |
Sgn | Y |
Sin | Y |
Sqr | Y |
Tan | Y |
Function | Supported |
---|---|
Choose | Y |
IIf | Y |
Switch | Y |
Function | Supported |
---|---|
Format | |
InStr | Y |
InStrRev | Y |
LCase[$] | Y |
Left[$] | Y |
Len | Y |
LTrim[$] | Y |
RTrim[$] | Y |
Trim[$] | Y |
Mid[$] | Y |
Replace | |
Right[$] | Y |
Space[$] | Y |
StrComp | Y |
StrConv | |
String[$] | Y |
StrReverse | Y |
UCase[$] | Y |
Copyright © 2005–2018. All rights reserved.