View Issue Details

IDProjectCategoryView StatusLast Update
0000092CaseTalk ModelerGeneration (SQL, XML, etc)public2022-01-10 20:40
ReporterMarco Wobben Assigned ToMarco Wobben  
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

Marco Wobben

Marco Wobben

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"")"
Marco Wobben

Marco Wobben

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 Marco Wobben New Issue
2012-05-16 21:36 Marco Wobben Status new => assigned
2012-05-16 21:36 Marco Wobben Assigned To => Marco Wobben
2012-11-05 16:35 Marco Wobben Category Model Generation => Generation
2016-01-20 12:56 Marco Wobben Category Generation => Generation (SQL, XML, etc)
2018-01-10 16:51 Marco Wobben Note Added: 0001070
2018-01-10 19:17 Marco Wobben Status assigned => resolved
2018-01-10 19:17 Marco Wobben Resolution open => fixed
2018-01-10 19:17 Marco Wobben Fixed in Version => 8.28
2022-01-10 20:40 Marco Wobben Note Added: 0002387
2022-01-10 20:40 Marco Wobben Status resolved => closed