SQLite UPDATE commands not updating the database

Question

I want to save a user's ScrollView position after they've left the View.

I'm doing this by trying to capture to position of getScrollY inside onPause and save it to a database, then retrieve it when the user returns.

I can successfully add and retrieve the position (Log.i("scrolly", Integer.toString(scrollY)) returns as expected), but the ScrollView isn't jumping to the right position.

Part of StoryBodyActivity:

public class StoryBodyActivity extends AppCompatActivity {

    private TextView storyBodyTextView;
    private ScrollView storyBodyScrollView;
    public int storyID;
    Parcelable state;
    int scrollY;

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        // Inflate the menu; this adds items to the action bar if it is present.
        getMenuInflater().inflate(R.menu.menu_story_body, menu);
        return true;
    }

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_story_body);

        Bundle extras = getIntent().getExtras();

        String story = extras.getString("story");
        storyID = extras.getInt("story_id");
        Log.i("stories", Integer.toString(storyID));

        storyBodyTextView = (TextView) findViewById(R.id.story_body_text_view);
        storyBodyScrollView = (ScrollView) findViewById(R.id.story_body_scroll_view);

        DatabaseHelper db = new DatabaseHelper(this);
        scrollY = db.getScrollPosition(storyID);
        Log.i("scrolly", Integer.toString(scrollY));

        storyBodyScrollView.scrollTo(0, scrollY);

        String storyBody = db.getStoryBody(storyID);

        storyBodyTextView.setText(Html.fromHtml(storyBody));

        if(state != null) {
            Log.d("pause", "trying to restore textview state..");
            storyBodyTextView.onRestoreInstanceState(state);
        }

        int scroll = storyBodyScrollView.getScrollY();
        Log.i("scroll", Integer.toString(scroll));

    }

    @Override
    public void onPause() {

        scrollY = storyBodyScrollView.getScrollY();
        Log.i("scroll", Integer.toString(scrollY));
        Log.i("insert", Integer.toString(storyID));
        DatabaseHelper db = new DatabaseHelper(this);
        db.setScrollPosition(scrollY, storyID);
        super.onPause();
    }

}

Part of my DatabaseHelper:

public class DatabaseHelper extends SQLiteAssetHelper {

    private static final int DATABASE_VERSION = 1;

    private static final String DATABASE_NAME = "database9.db";
    private static final String BOOKS = "books";
    private static final String AUTHORS = "authors";

    public DatabaseHelper (Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
        setForcedUpgrade();
    }

    public int setScrollPosition(int scrollY, int storyID) {

        String insertQuery = "UPDATE " + BOOKS + " SET scroll_position = '" + scrollY + "' WHERE id = '" + storyID + "'";
        Log.i("insert", insertQuery);
        SQLiteDatabase db = this.getWritableDatabase();
        db.execSQL(insertQuery);

        return 0;

    }

    public int getScrollPosition(int storyID) {

        int scrollPosition = 0;

        String selectQuery = "SELECT scroll_position FROM " + BOOKS + " WHERE id = '" + storyID + "'";

        SQLiteDatabase db = this.getWritableDatabase();
        Cursor cursor = db.rawQuery(selectQuery, null);

        // looping through all rows and adding to list
        if (cursor.moveToFirst()) {
            do {
                scrollPosition = cursor.getInt(0);
            } while (cursor.moveToNext());
        }

        return scrollPosition;

       }
}

UPDATE:

My schema:

    CREATE TABLE "books" (
`id` INTEGER NOT NULL,
`title` TEXT,
`author_id` INTEGER,
`collection` TEXT,
`body` TEXT,
`scroll_position` INTEGER,
PRIMARY KEY(`id`) )

Answer 1

In your INSERT command, you are passing a string as the id, whereas it expects an integer.

String insertQuery = "UPDATE " + BOOKS + " SET scroll_position = '" + scrollY + "' WHERE id = '" + storyID + "'";

You see? storyID is passed as a string ("' WHERE id = '" + storyID + "'")!!
Single quotes mark the id as a string.

If you create an integer column, it will never match a string.

CREATE TABLE "books" (
`id` INTEGER NOT NULL,
`title` TEXT,
`author_id` INTEGER,
`collection` TEXT,
`body` TEXT,
`scroll_position` INTEGER,
PRIMARY KEY(`id`) )

The id field is created as an integer (which is good).
But you can't then pass it a string in your commands (nor in your queries).

EDIT

You are also passing a string to the scroll_position field.
Which is an integer. And this also won't work.