View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000092CaseTalk ModelerGeneration (SQL, XML, etc)public2012-05-16 21:362022-01-10 20:40
ReporterBCP Software Assigned ToBCP Software  
PrioritynormalSeverityminorReproducibilitysometimes
Status closedResolutionfixed 
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

Activities

BCP Software

BCP Software

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"")"
BCP Software

BCP Software

2022-01-10 20:40

administrator   ~0002387

Closing automatically, stayed too long in resolved state. Feel free to re-open with additional information if you think the issue is not resolved.

Issue History

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