minor tweaks to date handling; clear caches when config updated; ensure date formats have correct symbols

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1234 f203690c-595d-4dc9-a70b-905162fa7fd2

implement Format with predefined formats

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1226 f203690c-595d-4dc9-a70b-905162fa7fd2

currency format uses parens; add bool predefined formats

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1225 f203690c-595d-4dc9-a70b-905162fa7fd2

beginnings of general format support

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1224 f203690c-595d-4dc9-a70b-905162fa7fd2

share nchars impl

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1223 f203690c-595d-4dc9-a70b-905162fa7fd2

cache and reuse DecimalFormat instances

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1222 f203690c-595d-4dc9-a70b-905162fa7fd2

implement FormatDateTime function

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1221 f203690c-595d-4dc9-a70b-905162fa7fd2

implement FormatCurrency and FormatPercent

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1220 f203690c-595d-4dc9-a70b-905162fa7fd2

fill out remaining tests for FormatNumber

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1219 f203690c-595d-4dc9-a70b-905162fa7fd2

add more numeric config

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1218 f203690c-595d-4dc9-a70b-905162fa7fd2

untested support for FormatNumber

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1217 f203690c-595d-4dc9-a70b-905162fa7fd2

implement DateDiff function

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1216 f203690c-595d-4dc9-a70b-905162fa7fd2

implement replace function

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1215 f203690c-595d-4dc9-a70b-905162fa7fd2

implement Val function

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1214 f203690c-595d-4dc9-a70b-905162fa7fd2

finish DateAdd function

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1213 f203690c-595d-4dc9-a70b-905162fa7fd2

initial work for DateAdd function

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1212 f203690c-595d-4dc9-a70b-905162fa7fd2

update javadocs for new function

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1211 f203690c-595d-4dc9-a70b-905162fa7fd2

rework string conversion to date; add support for dates with implicit years; implement DatePart function

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1210 f203690c-595d-4dc9-a70b-905162fa7fd2

fix broken test

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1209 f203690c-595d-4dc9-a70b-905162fa7fd2

reimplemnt and test financial functions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1208 f203690c-595d-4dc9-a70b-905162fa7fd2

add support for strconv function

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1207 f203690c-595d-4dc9-a70b-905162fa7fd2

handle am/pm suffix dependent on date/time config

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1206 f203690c-595d-4dc9-a70b-905162fa7fd2

handle alternate decimal separators based on numeric config

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1205 f203690c-595d-4dc9-a70b-905162fa7fd2

set default date/time and numeric config for a database

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1204 f203690c-595d-4dc9-a70b-905162fa7fd2

rework public expression api with better locale handling; support parsing of number strings with grouping separators

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1203 f203690c-595d-4dc9-a70b-905162fa7fd2

add support for monthname function; implement better string to date/time conversions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1202 f203690c-595d-4dc9-a70b-905162fa7fd2

add support for weekdayname function

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1201 f203690c-595d-4dc9-a70b-905162fa7fd2

implement IsNumeric; add support for hex/oct integer strings

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1200 f203690c-595d-4dc9-a70b-905162fa7fd2

implement IsNumeric; add support for hex/oct integer strings

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1199 f203690c-595d-4dc9-a70b-905162fa7fd2

spelling

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1198 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1197 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.2.0

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1195 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1194 f203690c-595d-4dc9-a70b-905162fa7fd2

more doc updates

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1193 f203690c-595d-4dc9-a70b-905162fa7fd2

refactor support for working with Value instances

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1192 f203690c-595d-4dc9-a70b-905162fa7fd2

add a bunch of javadocs for expr classes

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1191 f203690c-595d-4dc9-a70b-905162fa7fd2

minor refactor of function support; start adding top level docs for evaluation support

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1190 f203690c-595d-4dc9-a70b-905162fa7fd2

fix compiler warning

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1189 f203690c-595d-4dc9-a70b-905162fa7fd2

update parent pom; update urls for https

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1188 f203690c-595d-4dc9-a70b-905162fa7fd2

test TimeSerial; implement DateSerial

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1187 f203690c-595d-4dc9-a70b-905162fa7fd2

test custom EvalConfig; fix time format

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1186 f203690c-595d-4dc9-a70b-905162fa7fd2

add some date function tests

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1185 f203690c-595d-4dc9-a70b-905162fa7fd2

minor update

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1184 f203690c-595d-4dc9-a70b-905162fa7fd2

test number functions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1183 f203690c-595d-4dc9-a70b-905162fa7fd2

test more functions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1182 f203690c-595d-4dc9-a70b-905162fa7fd2

add ability to get original expression; implement some parsing tests

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1181 f203690c-595d-4dc9-a70b-905162fa7fd2

fix handling of certain field validator expressions; add some tests for various expressions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1180 f203690c-595d-4dc9-a70b-905162fa7fd2

handle alternate true/false constant values

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1179 f203690c-595d-4dc9-a70b-905162fa7fd2

add more tests; add not like

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1178 f203690c-595d-4dc9-a70b-905162fa7fd2

more tests

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1177 f203690c-595d-4dc9-a70b-905162fa7fd2

use common method pattern between ParseContext and EvalConfig

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1176 f203690c-595d-4dc9-a70b-905162fa7fd2

ditch default parse context

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1175 f203690c-595d-4dc9-a70b-905162fa7fd2

minor code warning cleanups

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1174 f203690c-595d-4dc9-a70b-905162fa7fd2

bump version for moderate feature update

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1173 f203690c-595d-4dc9-a70b-905162fa7fd2

merge branch exprs changes through r1171

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1172 f203690c-595d-4dc9-a70b-905162fa7fd2

merge trunk changes through r1170

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1171 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1170 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.1.12

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1168 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1167 f203690c-595d-4dc9-a70b-905162fa7fd2

add some tests for functions; fix said functions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1166 f203690c-595d-4dc9-a70b-905162fa7fd2

return all values in map so that default values, calc values, etc get returned to caller

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1165 f203690c-595d-4dc9-a70b-905162fa7fd2

more number format unit tests

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1164 f203690c-595d-4dc9-a70b-905162fa7fd2

add number format unit tests; update tests based on new formatting

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1163 f203690c-595d-4dc9-a70b-905162fa7fd2

add unit tests for property expression evaluation features

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1162 f203690c-595d-4dc9-a70b-905162fa7fd2

allow col validator to get this column by name

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1161 f203690c-595d-4dc9-a70b-905162fa7fd2

implement floating point number formatting which matches access

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1160 f203690c-595d-4dc9-a70b-905162fa7fd2

implement floating point number formatting which matches access

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1159 f203690c-595d-4dc9-a70b-905162fa7fd2

cleanup some fixmes

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1158 f203690c-595d-4dc9-a70b-905162fa7fd2

handle literal string default values

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1157 f203690c-595d-4dc9-a70b-905162fa7fd2

use decimal math context which matches access precision; tweak string to number conversion to match access

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1156 f203690c-595d-4dc9-a70b-905162fa7fd2

normalize decimals when used; convert number literals to decimal instead of double; handle int overflow for number literals

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1155 f203690c-595d-4dc9-a70b-905162fa7fd2

do not allow null result for conditions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1154 f203690c-595d-4dc9-a70b-905162fa7fd2

merge trunk changes through r1152

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1153 f203690c-595d-4dc9-a70b-905162fa7fd2

Create new usage map correctly when adding an index to an existing table.  fixes #147

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1152 f203690c-595d-4dc9-a70b-905162fa7fd2

knock out some fixmes; add support for custom function lookup and custom bindings passed into expression evaluation

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1151 f203690c-595d-4dc9-a70b-905162fa7fd2

Add some additional property keys and relevant enums for values

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1150 f203690c-595d-4dc9-a70b-905162fa7fd2

merge trunk changes through r1148

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1149 f203690c-595d-4dc9-a70b-905162fa7fd2

plug expr evaluation into columns/tables; create Identifier for tracking expression ids; support single quoting in expressions; tweak string to number coercion; implement topo sorter for calc col eval

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1148 f203690c-595d-4dc9-a70b-905162fa7fd2

start enforcing the required and no-zero len column properties

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1147 f203690c-595d-4dc9-a70b-905162fa7fd2

use specific exceptions for expr eval

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1146 f203690c-595d-4dc9-a70b-905162fa7fd2

fix null handling for string funcs

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1145 f203690c-595d-4dc9-a70b-905162fa7fd2

move rnd logic to RandomContext

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1144 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1143 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.1.11

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1141 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1140 f203690c-595d-4dc9-a70b-905162fa7fd2

merge trunk changes through r1138

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1139 f203690c-595d-4dc9-a70b-905162fa7fd2

update ddl flag for default properties even if type is explicitly provided.  fixes #146

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1138 f203690c-595d-4dc9-a70b-905162fa7fd2

Expose the ddl attribute on properties. Set the attribute appropriately for known builtin properties.  fixes issue #145

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1137 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1136 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.1.10

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1134 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1133 f203690c-595d-4dc9-a70b-905162fa7fd2

implement sql type to DataType conversions specific to access 2016 format

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1132 f203690c-595d-4dc9-a70b-905162fa7fd2

some more financial funcs, not all fully working

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1131 f203690c-595d-4dc9-a70b-905162fa7fd2

Add full support for access 2016 databases including the new 'Large Number' (aka Bigint) data type. Fixes feature #37

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1130 f203690c-595d-4dc9-a70b-905162fa7fd2

implement some financial functions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1129 f203690c-595d-4dc9-a70b-905162fa7fd2

more math unit tests

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1128 f203690c-595d-4dc9-a70b-905162fa7fd2

handle plus as a unary number modifier; handle precedence of plus/minus in more confusing math expressions

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/exprs@1127 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1126 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.1.9

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1124 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1123 f203690c-595d-4dc9-a70b-905162fa7fd2