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. The order of row insertion into the table has no significance since data is always inserted in the database according to the index.
The following code fragment inserts a new row.
tbl.InsertBegin(); tbl.Set( UL_TEXT("id"), 3 ); tbl.Set( UL_TEXT("lname"), "Carlo" ); tbl.Insert(); tbl.Commit();
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: