View Issue Details

IDProjectCategoryView StatusLast Update
0000092CaseTalk ModelerGeneration (SQL, XML, etc)public2018-01-10 19:17
ReporterwobbenAssigned Towobben 
Status resolvedResolutionfixed 
Product Version6.10 
Target VersionFutureFixed in Version8.28 
Summary0000092: MsAccess value contraints rule problem
DescriptionMsAccess can contain rules to provide for value constraints. However the generated "or" does not compute by MsAccess.
Steps To ReproducePerhaps a more modern syntax should be used to support newer versions of msaccess.
TagsNo tags attached.
CaseTalk Edition




2018-01-10 16:51

administrator   ~0001070

a line may contain:
  fld.ValidationRule = "a" OR "b" or "c"
but more modern script syntax may require:
  fld.ValidationRule = "in (""a"", ""b"", ""c"")"

Issue History

Date Modified Username Field Change
2012-05-16 21:36 wobben New Issue
2012-05-16 21:36 wobben Status new => assigned
2012-05-16 21:36 wobben Assigned To => wobben
2012-11-05 16:35 wobben Category Model Generation => Generation
2016-01-20 12:56 wobben Category Generation => Generation (SQL, XML, etc)
2018-01-10 16:51 wobben Note Added: 0001070
2018-01-10 19:17 wobben Status assigned => resolved
2018-01-10 19:17 wobben Resolution open => fixed
2018-01-10 19:17 wobben Fixed in Version => 8.28