Insert

Introduction

This tour gives you a practical mental model for inserting records with the Database Insert step in Server Connect. You will see where new row values are mapped, how inserted IDs flow into later steps, and which checks help you keep create operations safe in a real project.

Map inputs to columns

Validate before inserting

Insert Records

Use the Database Insert step in Server Connect to insert new rows. Map input values (form fields) to your table columns.

Map form inputs to table columns

Use the Insert step for new rows

Use Inserted IDs

When needed, capture the inserted record ID and use it in subsequent steps (e.g. insert into a related table).

Read inserted id output

Use it for related inserts

Validate Before Insert

Validate inputs on both client and server. For example, check if a record already exists before inserting.

Validate inputs server-side

Prevent duplicates where needed

Next steps

Return to the Database Operations menu to continue with Queries, Insert, Update, Delete, or Paging.

Go back to Database Operations

Pick the next tour