Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » UltraLite - .NET Programming » Understanding UltraLite.NET development » Accessing and manipulating data with the Table API


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.


The following code inserts a new row.

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

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.