int64_t key; // ... auto accounts_rs=accounts::create(conn); accounts_rs->search("account_id", "=", key); auto a=accounts->only(); std::cout << "Previous code: " << a->code.value() << std::endl; a->code.value("Acct6"); a->update();
The row objects for each resultset class,
classname::base::rowvalue() and
isnull(), returning the value of that column
in the row.
value(v) sets a
new value of the column, and
update() executes an SQL
UPDATE statement that updates all modified columns.
If no columns were modified, update() does
nothing.
The above example executes SQL equivalent to
“UPDATE accounts SET code='Acct6' where
account_id=”.
key
Pass a nullptr to value() to
SET the column to an SQL NULL,
for those columns that are nullable.