//Modify customer
customer.set( "LASTNAME", "Pavick" );
//Build apply changes command
ApplyChangesCommand apply = Command.FACTORY.createApplyChangesCommand();
apply.setConnection( getConnection() );
//Manually create and add update command
Command update = Command.FACTORY.createCommand( "update CUSTOMER set LASTNAME = :LASTNAME where ID = :ID" );
update.addParameter( "LASTNAME", SDODataTypes.STRING );
update.addParameter( "ID", SDODataTypes.INTEGER );
apply.addUpdateCommand( customer.getType(), update );
//Flush changes
apply.execute( root );
//Verify changes
root = select.executeQuery();
assertEquals( "Pavick", root.getString( "CUSTOMER[1]/LASTNAME" ) );