• Home
  • Free Trial
  • Sign In
  • Plans
  • Tracks
  • Library
  • Community
  • Support
  • Jobs
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • 21st Century Skills
      • • Android
      • • APIs
      • • Business
      • • C#
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Equity, Diversity, and Inclusion (EDI)
      • • Go
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • PHP
      • • Python
      • • Quality Assurance
      • • Ruby
      • • Security
  • Stanley Aaron Meki
    Stanley Aaron Meki
    6,345 Points

    Next, add another create statement called CREATE_CAR_MODELS that is public static final. Give it a primary key called _i

    Posted September 5, 2017 1:06am by Stanley Aaron Meki
    Stanley Aaron Meki
    6,345 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Creating a SQLite Table

    0 Answers

  • adana kebap
    adana kebap
    179 Points

    hey! i am new here and love the videos but this video is like a bit old :s can you update please?

    Posted July 10, 2017 7:54pm by adana kebap
    adana kebap
    179 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Setting Up the Database

    1 Answer

  • Rosario Alessandro Cali
    Rosario Alessandro Cali
    5,371 Points

    ADB Shell closes a few seconds after it opens. Why?

    Posted June 13, 2017 5:19pm by Rosario Alessandro Cali
    Rosario Alessandro Cali
    5,371 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Using sqlite3 to View Databases

    0 Answers

  • vin kum
    vin kum
    3,546 Points

    Why are we overriding onResume?

    Posted January 11, 2017 6:17am by vin kum
    vin kum
    3,546 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Using sqlite3 to View Databases

    0 Answers

  • Aaron Goodman
    Aaron Goodman
    3,953 Points

    Android Studio Could not find method runProguard() for arguments

    Posted December 28, 2016 8:57pm by Aaron Goodman
    Aaron Goodman
    3,953 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Setting Up the Database

    0 Answers

  • George Sideris
    PLUS
    George Sideris
    Courses Plus Student 3,712 Points

    I create the table also add the TEXT ...

    Posted November 11, 2016 9:17pm by George Sideris
    George Sideris
    Courses Plus Student 3,712 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Creating a SQLite Table

    2 Answers

  • Tuan Zen
    Tuan Zen
    6,882 Points

    sqlite .tables only show android_metadata

    Posted June 24, 2016 6:53pm by Tuan Zen
    Tuan Zen
    6,882 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Using sqlite3 to View Databases

    0 Answers

  • vicente lee
    vicente lee
    6,271 Points

    yet another typo in the copy paste code

    Posted May 16, 2016 4:09pm by vicente lee
    vicente lee
    6,271 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Adding the Annotations Table

    0 Answers

  • André Gomes
    André Gomes
    3,537 Points

    SQL creating Table error

    Posted September 3, 2015 7:24pm by André Gomes
    André Gomes
    3,537 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Using sqlite3 to View Databases

    0 Answers

  • Gerardo Guzman
    Gerardo Guzman
    4,480 Points

    MemeItemFragment, what is this code segment for?

    Posted August 11, 2015 5:40pm by Gerardo Guzman
    Gerardo Guzman
    4,480 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Using sqlite3 to View Databases

    1 Answer

  • Bhekimpilo Ncube
    Bhekimpilo Ncube
    4,157 Points

    Bummer! Something is wrong with the statement: CREATE TABLE CAR_MAKERS (_id INTEGER PRIMARY KEY AUTOINCREMENT,ASSETTEXT

    Posted July 4, 2015 3:30am by Bhekimpilo Ncube
    Bhekimpilo Ncube
    4,157 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Creating a SQLite Table

    2 Answers

  • Johannes Sunnhagen
    Johannes Sunnhagen
    2,621 Points

    how do i open the adb shell? from where?

    Posted June 26, 2015 7:52am by Johannes Sunnhagen
    Johannes Sunnhagen
    2,621 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Using sqlite3 to View Databases

    2 Answers

  • Jessica Soruco
    Jessica Soruco
    5,843 Points

    permission denied after openning adb shell and then cd data/data

    Posted June 10, 2015 1:10pm by Jessica Soruco
    Jessica Soruco
    5,843 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Using sqlite3 to View Databases

    2 Answers

  • Guy Bridge
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Guy Bridge
    Android Development Techdegree Graduate 24,991 Points

    Getting Error: E/SQLiteLog﹕ (1) AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY

    Posted June 3, 2015 12:51pm by Guy Bridge
    .a{fill-rule:evenodd;}techdegree seal-36
    Guy Bridge
    Android Development Techdegree Graduate 24,991 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Adding the Annotations Table

    2 Answers

  • Adlight Sibanda
    Adlight Sibanda
    5,701 Points

    Finally, add the statement to execute the creation of your new table

    Posted May 29, 2015 12:15pm by Adlight Sibanda
    Adlight Sibanda
    5,701 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Creating a SQLite Table

    2 Answers

  • Adlight Sibanda
    Adlight Sibanda
    5,701 Points

    confused/lost on statement type

    Posted May 29, 2015 9:37am by Adlight Sibanda
    Adlight Sibanda
    5,701 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Creating a SQLite Table

    1 Answer

  • Adlight Sibanda
    Adlight Sibanda
    5,701 Points

    ANOTHER CREATE STATEMENT

    Posted May 29, 2015 8:31am by Adlight Sibanda
    Adlight Sibanda
    5,701 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Creating a SQLite Table

    4 Answers

  • Adlight Sibanda
    Adlight Sibanda
    5,701 Points

    not sure what is going wrong here.

    Posted May 28, 2015 11:58pm by Adlight Sibanda
    Adlight Sibanda
    5,701 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Creating a SQLite Table

    3 Answers

  • Chad Johnson
    Chad Johnson
    10,936 Points

    Not sure why my code is not correct, it is not accepting format in previous video

    Posted April 6, 2015 2:31pm by Chad Johnson
    Chad Johnson
    10,936 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Creating a SQLite Table

    2 Answers

  • minzawmra
    PLUS
    minzawmra
    Courses Plus Student 15,682 Points

    Why call MemeDataSource from MemeItemFragment?

    Posted March 24, 2015 11:57am by minzawmra
    minzawmra
    Courses Plus Student 15,682 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Using sqlite3 to View Databases

    0 Answers

  • Noah Schill
    Noah Schill
    10,020 Points

    sqlite not installed???

    Posted March 11, 2015 10:51pm by Noah Schill
    Noah Schill
    10,020 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Using sqlite3 to View Databases

    1 Answer

  • Danial Goodwin
    Danial Goodwin
    13,247 Points

    Using sqlite3 in adb shell error: "could not load needed library 'libncurses.so' for 'sqlite3' ... cannot link executab"

    Posted December 15, 2014 3:05am by Danial Goodwin
    Danial Goodwin
    13,247 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Using sqlite3 to View Databases

    1 Answer

  • Erin Kapoor
    Erin Kapoor
    412 Points

    When to implement super()

    Posted November 12, 2014 12:29pm by Erin Kapoor
    Erin Kapoor
    412 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Setting Up the Database

    1 Answer

  • Raghda Talaa't
    Raghda Talaa't
    2,944 Points

    Where is the link for the StackOverFlow?

    Posted November 5, 2014 9:53am by Raghda Talaa't
    Raghda Talaa't
    2,944 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Design Considerations for SQLite

    1 Answer

  • Rommel Paras
    PLUS
    Rommel Paras
    Courses Plus Student 3,483 Points

    Some typos on the copy/paste code

    Posted November 5, 2014 4:24am by Rommel Paras
    Rommel Paras
    Courses Plus Student 3,483 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Adding the Annotations Table

    2 Answers

  • Richard Luick
    Richard Luick
    10,955 Points

    android.database.sqlite.SQLiteException: near "CREATE_TABLE"

    Posted October 24, 2014 11:09pm by Richard Luick
    Richard Luick
    10,955 Points
    • Android
    • Android Data Persistence
    • Using SQLite for Structured Data
    • Adding the Annotations Table

    1 Answer

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.

    Treehouse

  • About
  • Blog
  • Careers
  • Community
  • Stories
  • Shop
  • Contact
  • Gift Card

See Full Catalogue

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis
  • UX Design

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Plans
  • Perks
  • Public Library Access
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2023 Treehouse Island, Inc.