Views and updates

Some views cannot be updated for the following reasons:

• The views contain table joins on keys other than primary keys.

• The views include security settings that prohibit updates.

If the write process fails, you can view the status in the Error panel. You can also monitor the StatusDesc, and StatusError properties by using text fields on the InTouch window for run-time display.

To make a change to data in the data grid

1. Ensure that the ConfiguredReadOnly custom property value is False.

2. Select Runtime.

3. Enter a SQL statement or the name of a database table or view.

4. Select Retrieve. This example shows data from the customer table in AdventureWorks. You will modify a phone number.

5. Select the phone number that you must modify. The area becomes editable.

   

6. Change the last four digits of the phone number to 0122.

7. Select an area outside the edit area. The Write button becomes enabled.

   

8. Select Write.

9. To verify the change, select Retrieve.