The steps to insert a row are very similar to those for updating rows, except that there is no need to locate a row in the table before carrying out the insert operation.

If you do not set a value for one of the columns, and that column has a default, the default value is used. If the column has no default, one of the following entries is used:

• For nullable columns, NULL.
• For numeric columns that disallow NULL, zero.
• For character columns that disallow NULL, an empty string.
• To explicitly set a value to NULL, use the SetNull method.

 Example

ULTable * tbl = conn->OpenTable("MyTable");
bool success;
tbl->InsertBegin();  // enter "Insert mode"
tbl->SetInt("id", 3);
tbl->SetString("lname", "Smith");
tbl->SetString("fname", "Mary");
success = tbl->Insert();
conn->Commit();
tbl->Close();