The Insert component permits the Procedure-generated
insertion of a new row of data into any database table shown in the Palette's
Resources.
Upon landing in the Workspace, the component will
be displayed with two areas: a header field to receive the database
table name and a body data
line (for one field of the database row to be inserted) consisting of: Run-time
switch +Value (incoming data), and In Field (target repository of
the incoming data).
Resize the
object to provide as many In Field's as are required to
populate the new row of data to be added to the selected database table.
To specify the database table insert, with the resized Insert component selected
(control points are visible):
- select the desired database table (Palette's Resources - Database),
this will load the database name into the component and
display, in the Palette, the available fields;
- select the desired target field (Palette's Resources - Field), repeat
for each In Field;
- specify the Value either hard-coded (set run-time switch to white
and type data into Value field) or loaded at run-time (set switch
to grey and load data source reference into Value field);
- complete additional Value's,
if any;
- complete additional In Field's, if any;
- drag Success? component
from Inspector and connect as required (optional).
Caution:
- If the Success? component,
located in the Database Insert Inspector, is useful to your Procedure,
you should attach appropriate actions to the Yes and No exits.
- Read up on the use
of the Packet option.