To define "update" object
Name – The name of the "update" object. The name is used to identify and access this object from code.
Show name – If selected, the name of this "update" object is displayed on a presentation diagram.
Ignore – If selected, this "update" object is excluded from the model.
Show at runtime
– If selected, this "update" object is visible on a presentation at runtime.
Database – The name of AnyLogic database object associated with the actual database you want to modify.
Table – The name of the database table you want to update with new values.
Key column – The key column of the table. When updating rows of the database table, the value specified for this particular column will be used to identify the table row the user wants to update.
Key and value columns – Here you specify, what particular columns of the database table you will update. The first uneditable column of the table contains the name of the key column you have specified previously. In the succeeding columns you should specify names of the columns you will update. To add new columns into the Key and value columns table, successively double-click in the rightmost column of the table and enter the name of the required column of the database table there.
Values – Here you specify a set of values you want to add into the given database table. Values are defined row by row: in the first column you define value of the key column and in succeeding columns you define values you want to update in the table row holding the specified value of the key column. You may leave some cells blank and enter values only in required columns. To add a value, first double-click in the corresponding cell of the table and then enter the value there.
Update the database table using the corresponding API of the Update object. The most frequently needed function is the following: