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. Click Runtime.

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

4. Click 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. Click an area outside the edit area. The Write button becomes enabled.

   

8. Click Write.

9. To verify the change, click Retrieve.