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 | BCP Software | Assigned To | BCP Software | ||
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 | BCP Software | New Issue | |
2020-06-25 16:55 | BCP Software | Status | new => assigned |
2020-06-25 16:55 | BCP Software | Assigned To | => BCP Software |
2020-06-28 20:57 | BCP Software | Status | assigned => resolved |
2020-06-28 20:57 | BCP Software | Resolution | open => fixed |
2020-06-28 20:57 | BCP Software | Fixed in Version | => 11.0 |
2020-06-28 20:57 | BCP Software | Note Added: 0001686 | |
2020-07-03 14:08 | BCP Software | Fixed in Version | 11.0 => 10.2.1 |
2020-07-03 14:08 | BCP Software | Target Version | 11.0 => 10.2.1 |
2022-01-10 20:40 | BCP Software | Note Added: 0004122 | |
2022-01-10 20:40 | BCP Software | Status | resolved => closed |