Updating Records (Recordset Operations dialog box)

Some hosts allow you to directly update a new record as part of a recordset on the terminal screen. To deal with this scenario, select the Host supports direct record update check box and choose from one or both of options below.

If you attach an event handler to the recordset that has an Update Record event implemented, a lightning bolt () is displayed to the left of this option. This is a reminder that the event handler may include logic that overrides or extends any of the settings you configure below.

Execute operation before update

Select this check box and choose an operation to execute before changing the value of the new record.

Example:

Execute operation after update

Select this check box and choose an operation to execute after changing the value of the new record.

Examples:

Note: Modifying records in a recordset can create synchronization problems between the Host Integrator and the host. For example, if Host Integrator updates a record in a recordset and there are no indicators that it should wait for the host to commit to a modification, Host Integrator reports this as an error. The synchronization problem occurs if the Design Tool refreshes the internal view of the screen in the Terminal window before the host has received the new data. For example, if you reformat a date field from "12.10.01" to "Oct 12 2001", the Host Integrator record cache may have the 12.10.01 version of the date if there is not synchronization in the form of an "after update" operation. To fix this, create an operation that uses one or more Host Events commands that makes Host Integrator wait until the host has returned the updated record. Then, select the Execute operation after update check box described above and choose the configured operation from the list.
 

Related Topics
Bullet How to add a recordset
Bullet How to test a recordset