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.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 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.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|