The following procedure updates a row.
Move to the row you want to update.
You can move to a row by scrolling through the table or by searching the table using find and lookup methods.
Enter update mode.
For example, the following instruction enters update mode on table tbl.
Set the new values for the row to be updated. For example, the following instruction sets the id column in the buffer to 3.
tbl.Set( UL_TEXT("id"), 3 );
Execute the Update.
After the update operation, the current row is the row that has been updated.
The UltraLite C++ API does not commit changes to the database until you commit them using
conn->Commit(). See Managing transactions.
Do not update the primary key of a row: delete the row and add a new row instead.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|