Inserted row with identity column does not show generated value, or save (4312612)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Inserted row with identity column does not show generated value, or save
Description

View Data in a table that has a PK which generates its own unique #. Click to insert a row in the middle of the table & type in valid data. No errors/warnings are given & it acts like it saves the new row but it doesn't assign value to the PK field. When table is closed and opened again, the new row is not there.
Cause
Issue only occurs with tables that have columns where the value is automatically generated using IDENTITY e.g.
```
CREATE TABLE new_employees
(
 id_num int IDENTITY(1,1),
 fname varchar (20),
 minit char(1),
 lname varchar(30)
)
```
Resolution

WORKAROUND

Read all rows in table first and then add row at the end

STATUS

Waiting for fix in a future release of Toad for SQL Server
Defect ID

TSS-122

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title