Ch 12, Try It Out, p434

Brian419 · November 29th, 2016, 10:01 PM

Hi!
In the PlanetWrox database I'm having an issue adding data to the Review table that I did not have when adding data to the Genre table.

Try It Out - Creating a Relationship between Two Tables.
Using: Windows 7, VS Community 2013, and SQL Server Express 2012

So far, everything up to this point has worked ok.

Step 9 - In the PlanetWrox database, when I enter a new row in the Review table a little red circle with a white exclamation point appears after each field until I tab or click in the next row to add a new row of data. However, the Id, CreateDateTime, and UpdateDateTime columns all remain null.
The little red circle w/white exclamation point remains with the Id column and when I hover over it, displays the message:
"This row was successfully committed to the database.
However, a problem occurred when attempting to retrieve the data back after the commit.
Because of this, the displayed data in this row is read-only.
To fix this problem, please re-run the query."

I click the X, or Ctrl F4, to close the designer, and right-click the Review table and choose Edit Top 200 Rows to display it again. Now the Id column has the correct sequential number, and both the CreateDateTime and UpdateDateTime columns show the correct date/time. I didn't have this issue when entering data for the Genre table.

Should I have to close the designer and rerun the query after entering a row of data in order for the correct information to appear?

Fyi... not sure if it matters but I did not delete the PlanetWroxTemp database.

-Thanks for any help you can provide!

Imar · November 30th, 2016, 08:56 AM

There's an Execute / Refresh button on the toolbar. You can click that (or press Ctrl+R) to reload the changes. Then you'll see the data you entered, along with the auto generated IDs.

Hope this helps,

Imar