Programming Guide

Prepares screen for data entry

int sm_tm_command ("NEW [ tableViewName [ tableViewScope ] ]");

tableViewName

The name of a table view in the current transaction. A table view can only be specified if the mode has already been set to new. This parameter is case sensitive.

If tableViewName is specified, the command is applied according to the tableViewScope parameter. Since the entire table view tree might not be included, this is known as a partial command, and sm_tm_command sets TM_FULL to 0.

If tableViewName is not specified, the command is applied for each table/server view, starting with the root table view. This is known as a full command, and sm_tm_command sets TM_FULL to 1.

tableViewScope

One of the following parameters, which must be preceded by a table view name.

• TV_AND_BELOW which applies the command to the specified table view and all table views below it on the tree. If no parameter is specified, the transaction manager acts as though TV_AND_BELOW was supplied.

• BELOW_TV which applies the command to the table views below the specified table view.

• TV_ONLY which applies the command to the specified table view only.

• SV_ONLY which applies the command only to the table views of the specified server view.

NEW clears each field and prepares it for data entry. To insert data successfully, all the fields in a table view that are participating in the SQL INSERT statement need to have the same number of occurrences.

After you select NEW, the following steps occur:

1. If you have made changes in the table views on which this command operates in a previous NEW, COPY or SELECT, you are prompted to discard your changes. If you choose OK, changes are discarded and fields in the specified table views are cleared. If you choose Cancel, you return to the screen so you can save your changes. You must then select NEW again.
2. The fields are cleared of all previous values.
3. The transaction mode is set to new. By default, this mode clears all the protection bits in updatable table views to reflect that data entry is available in those widgets.
4. Before image processing for the screen is enabled. Any changes made to the screen following this step can then be processed using SAVE.

Push buttons and menu selections for the NEW command can choose to set the class property to new_button. By default, new_button is active in initial and view modes.

To save the additions, select SAVE as the next transaction command. To discard the additions, select CLOSE or FORCE_CLOSE.

If you are entering a series of rows, COPY copies the data on a screen so it can then be edited, without having to enter the data again.

The following requests can be generated by the NEW command to ascertain whether the changes from the previous command have been saved and, if desired, discard those changes:

• TM_PRE_CLOSE (described under CLOSE)

• TM_CLOSE (described under CLOSE)

• TM_QUERY (described under CLOSE)

• TM_DISCARD (described under CLOSE)

• TM_POST_CLOSE (described under CLOSE)

  Table 8-25 Request events for NEW

  Request	Traversal	Typical Processing
  TM_PRE_NEW	By table/server view from the specified table view	Do nothing
  TM_NEW	By table/server view from the specified table view	Do nothing (sm_bi_initialize and sm_bi_copy are called for the table view by the transaction manager after this request)
  TM_POST_NEW	By table/server view from the specified table view	Do nothing

---

---