Filter
Top Products
About controlling updates
192 DataWindow .NET
If using a Stored Procedure or External data source
If the data source is Stored Procedure or External, you can use the
FindNextModiedRow method to write your own update code.
What you can do
You can:
• Allow updates in a DataWindow object associated with multiple tables or
a view; you can define one of the tables as being updatable
• Prevent updates in a DataWindow object associated with one table
• Prevent updates to specific columns in a DataWindow object that is
associated with an updatable table
• Specify which columns uniquely identify a row to be updated
• Specify which columns will be included in the
WHERE clause of the
UPDATE or DELETE statement DataWindow Designer generates to update
the database
• Specify whether DataWindow Designer generates an
UPDATE statement,
or a
DELETE then an INSERT statement, to update the database when users
modify the values in a key column
Updatability of views
Some views are logically updatable; some are not. For the rules your DBMS
follows for updating views, see your DBMS documentation.
❖ To specify update characteristics for a DataWindow object:
1 Select Rows>Update Properties from the menu bar.
The Specify Update Properties dialog box displays.
2 To prevent updates to the data, make sure the Allow Updates box is not
selected.
To allow updates, select the Allow Updates box and specify the other
settings as described below.
3 Click OK.