View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update | 
|---|---|---|---|---|---|
| 0002565 | CaseTalk Modeler | Generation (SQL, XML, etc) | public | 2020-06-25 16:55 | 2022-01-10 20:40 | 
| Reporter | Marco Wobben | Assigned To | Marco Wobben | ||
| Priority | normal | Severity | feature | Reproducibility | N/A | 
| Status | closed | Resolution | fixed | ||
| Target Version | 10.2.1 | Fixed in Version | 10.2.1 | ||
| Summary | 0002565: ER/Studio script datatype change | ||||
| Description | ER/Studio script generator does not contain datatype specific details or support the Default Value for roles. This could be added in the script generator.. | ||||
| Additional Information | Set MyDomain = MyDict.Domains.Add("BirthDate", "BirthDate") MyDomain.Datatype = "DATE" MyDomain.Nullable = False Set MyDomain = MyDict.Domains.Add("FirstName", "FirstName") MyDomain.Datatype = "NVARCHAR" MyDomain.DataLength = 255 MyDomain.Nullable = False ' Declarative Default: Specifies the default domain value when a value is not explicitly specified during an insert. DEFAULT definitions can be applied to any columns except those defined as timestamp, or those with the IDENTITY property. Only a constant value, such as a character string; a system function, such as SYSTEM_USER(); a NULL; or a constraint name can be assigned to a DEFAULT. MyDomain.DeclaredDefault = "user_name()" | ||||
| Tags | No tags attached. | ||||
| CaseTalk Edition | unknown | ||||
| Added script support for - Domain.DataLength - Column.DefaultValue | |
| 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 | 
|---|---|---|---|
| 2020-06-25 16:55 | Marco Wobben | New Issue | |
| 2020-06-25 16:55 | Marco Wobben | Status | new => assigned | 
| 2020-06-25 16:55 | Marco Wobben | Assigned To | => Marco Wobben | 
| 2020-06-28 20:57 | Marco Wobben | Status | assigned => resolved | 
| 2020-06-28 20:57 | Marco Wobben | Resolution | open => fixed | 
| 2020-06-28 20:57 | Marco Wobben | Fixed in Version | => 11.0 | 
| 2020-06-28 20:57 | Marco Wobben | Note Added: 0001686 | |
| 2020-07-03 14:08 | Marco Wobben | Fixed in Version | 11.0 => 10.2.1 | 
| 2020-07-03 14:08 | Marco Wobben | Target Version | 11.0 => 10.2.1 | 
| 2022-01-10 20:40 | Marco Wobben | Note Added: 0004122 | |
| 2022-01-10 20:40 | Marco Wobben | Status | resolved => closed | 
