Treehouse | Community | Creating a SQLite Table

🚀 In our NEW AI Bootcamp you'll build a working app in 28 days, no experience required. Free to all subscription levels.

Join the Treehouse affiliate program and earn 25% recurring commission! 🤑

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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
0 Answers
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
1 Answer
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
0 Answers
vin kum
3,546 Points
Why are we overriding onResume?

Posted January 11, 2017 6:17am by vin kum

vin kum
3,546 Points
0 Answers
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
0 Answers
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
2 Answers
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
0 Answers
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
0 Answers
André Gomes
3,537 Points
SQL creating Table error

Posted September 3, 2015 7:24pm by André Gomes

André Gomes
3,537 Points
0 Answers
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
1 Answer
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
2 Answers
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
2 Answers
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
2 Answers
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

Guy Bridge
Android Development Techdegree Graduate 24,991 Points
2 Answers
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
2 Answers
Adlight Sibanda
5,701 Points
confused/lost on statement type

Posted May 29, 2015 9:37am by Adlight Sibanda

Adlight Sibanda
5,701 Points
1 Answer
Adlight Sibanda
5,701 Points
ANOTHER CREATE STATEMENT

Posted May 29, 2015 8:31am by Adlight Sibanda

Adlight Sibanda
5,701 Points
4 Answers
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
3 Answers
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
2 Answers
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
0 Answers
Unsubscribed User
10,020 Points
sqlite not installed???

Posted March 11, 2015 10:51pm by Unsubscribed User

Unsubscribed User
10,020 Points
1 Answer
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
1 Answer
Erin Kapoor
412 Points
When to implement super()

Posted November 12, 2014 12:29pm by Erin Kapoor

Erin Kapoor
412 Points
1 Answer
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
1 Answer
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
2 Answers
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
1 Answer

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