Inserting rows

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.

Example

The following code inserts a new row.

t.InsertBegin();
t.SetInt( id, 3 );
t.SetString( lname, "Carlo" );
t.Insert();

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 setDBNull method.

For update operations, an insert is applied to the database in permanent storage when a commit is carried out. In AutoCommit mode, a commit is carried out as part of the insert method.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0