View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0006937 | VALENTINA STUDIO | Tool - Data Editor Related | public | 2014-09-17 09:47 | 2014-09-17 14:18 |
Reporter | Sergey Pashkov | Assigned To | Sergey Pashkov | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | resolved | Resolution | fixed | ||
Product Version | 5.5.8 | ||||
Target Version | 5.6 | Fixed in Version | 5.6 | ||
Summary | 0006937: Put foreign key values before INSERT into the related table | ||||
Description | Adding a record into the related table fails sometimes, for example, when foreign key field is not nullable and it doesn't have a default value. We can fill foreign key values from parent table before insert to avoid this error. | ||||
Tags | No tags attached. | ||||
Working with DB: | Not specified | ||||
Version of your DB: | |||||
Usually we try to add an EMPTY record to the related table and only after that link this record to parent in the top grid. | |
Date Modified | Username | Field | Change |
---|---|---|---|
2014-09-17 09:47 | Sergey Pashkov | New Issue | |
2014-09-17 09:47 | Sergey Pashkov | Status | new => assigned |
2014-09-17 09:47 | Sergey Pashkov | Assigned To | => Sergey Pashkov |
2014-09-17 09:49 | Sergey Pashkov | Note Added: 0007922 | |
2014-09-17 14:18 | Sergey Pashkov | Status | assigned => resolved |
2014-09-17 14:18 | Sergey Pashkov | Fixed in Version | => 5.6 |
2014-09-17 14:18 | Sergey Pashkov | Resolution | open => fixed |