0002800: Add Value constraints as Reference Values

ID	Project	Category	View Status	Date Submitted	Last Update

0002800	CaseTalk Modeler	Generation (SQL, XML, etc)	public	2021-01-25 16:39	2022-01-10 20:40

Reporter	BCP Software	Assigned To	BCP Software
Priority	normal	Severity	feature	Reproducibility	have not tried
Status	closed	Resolution	fixed
Target Version	11.0	Fixed in Version	11.0

Summary	0002800: Add Value constraints as Reference Values
Description	Value constraints in ER Studio are implemented as a Rule, it would be helpful to also add them as ReferenceValues.
Tags	No tags attached.

CaseTalk Edition	unknown

BCP Software 2021-01-25 16:40 administrator ~0001861	Set Domain_Number = MyDictionary.Domains.Item("Number") if Domain_Number is Nothing then Set Domain_Number = MyDictionary.Domains.Add("Number", "Number") end if Domain_Number.DataType = "INTEGER" Set Rule_Number = MyDictionary.Rules.Item("Number") if Rule_Number is Nothing then Set Rule_Number = MyDictionary.Rules.Add("Number", "@var in (""1"", ""2"", ""3"")") end if Domain_Number.RuleId = Rule_Number.ID ' and as reference value Set ReferenceValue_Number = MyDictionary.ReferenceValues.Item("Number") if ReferenceValue_Number is Nothing then Set ReferenceValue_Number = MyDictionary.ReferenceValues.Add("Number") end if Set ReferenceValue_Number.IsRange = False ReferenceValue_Number.Values.Add("1","1") ReferenceValue_Number.Values.Add("2","2") ReferenceValue_Number.Values.Add("3","3") Domain_Number.ReferenceValueId = ReferenceValue_Number.ID

BCP Software 2022-01-10 20:40 administrator ~0004282	Closing automatically, stayed too long in resolved state. Feel free to re-open with additional information if you think the issue is not resolved.

Date Modified	Username	Field	Change
2021-01-25 16:39	BCP Software	New Issue
2021-01-25 16:39	BCP Software	Status	new => assigned
2021-01-25 16:39	BCP Software	Assigned To	=> BCP Software
2021-01-25 16:40	BCP Software	Status	assigned => resolved
2021-01-25 16:40	BCP Software	Resolution	open => fixed
2021-01-25 16:40	BCP Software	Fixed in Version	=> 11.0
2021-01-25 16:40	BCP Software	Note Added: 0001861
2022-01-10 20:40	BCP Software	Note Added: 0004282
2022-01-10 20:40	BCP Software	Status	resolved => closed