Chapter 7 WORKING WITH VIEWS 417 that specifies
Chapter 7 WORKING WITH VIEWS 417 that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint. The statement has been terminated. Because this INSERT results in data that was not visible through the view, it is not allowed. This may be advantageous for some databases if you want to restrict what values are inserted into the view. In this particular case, it prevents the addition of both Authors and Titles, because you can t use a single statement to INSERT into both tables, and either INSERT creates data that is not visible through the view. Data updates, other than inserts, are still allowed, as long as the resulting data is still visible through the view. Enabling users to add data to a view that will not then be visible leaves two problems. After the INSERT has been carried out, the data will not be visible, which causes some users to attempt additional updates (thinking the previous one failed). If the users are aware that the data INSERT did succeed, they are still unable to check the accuracy of the UPDATE, because the data is not visible. You should consider using the WITH CHECK OPTION with all views to limit data inserts and avoid user confusion. To add data through a view, follow Step by Step 7.5.
For high quality website hosting services please check java web hosting website.