create table query are not perform in android connect to SQLite database

Question

private static final String dbname="student.db";
private static final String tblname="detail";
private static final String c1="uname";
private static final String c2="id";
private static final String c3="pass";
private static final String c4="add";
private static final String c5="gender";
private static final String c6="sequrity";
private static final String c7="answer";


public Databasehelper(Context context) 
{
    super(context, dbname, null, 1);

}

@Override
public void onCreate(SQLiteDatabase db) 
{
    String q= "create table "+tblname+"("
        +c1+" varchar(10),"
        +c2+" varchar(20),"
        +c3+" varchar(10),"
        +c4+" varchar(100),"
        +c5+" varchar(10),"
        +c6+" varchar(100),"
        +c7+" varchar(10))";

        db.execSQL(q);
}

in above coding in create table define Error

it not define Error but when i run avd than my application is unfortunatlly stoped ... chaek mya create table query is right or not — Jadav Ramesh, Oct 27 '17 at 05:02
Suggestion: Use the Room library. https://developer.android.com/topic/libraries/architecture/room.html — OneCricketeer, Oct 27 '17 at 05:03
There **is** an error. https://stackoverflow.com/questions/23353173/unfortunately-myapp-has-stopped-how-can-i-solve-this — OneCricketeer, Oct 27 '17 at 05:04
when i run this project it create only database not create table — Jadav Ramesh, Oct 27 '17 at 05:05
just when your application is crashed go to Android monitor on the bottom of your android studio screen and paste what's on your logcat here. — , Oct 27 '17 at 05:05
Please [edit] your question with your logs. Also, you will want to clear the application data. For more information. https://stackoverflow.com/questions/21881992/when-is-sqliteopenhelper-oncreate-onupgrade-run — OneCricketeer, Oct 27 '17 at 05:06
please don't edit your question to be something completely different, rendering any older comments or answers obsolete — laalto, Oct 27 '17 at 08:40

score 0 · Answer 1 · answered Oct 27 '17 at 05:11

0

You can update your query with this

"create table "+tblname+"("+c1+" TEXT, "+c2+" TEXT, "+c3+" TEXT, "+c4+" TEXT, "+c5+" TEXT, "+c6+" TEXT, "+c7+" TEXT)";

In SQLite TEXT is same as VARCHAR you can use TEXT as this answer.

You can also check commonly asked quetions for sqlite here

answered Oct 27 '17 at 05:11

Lalit Jadav

1,409
1
15
38

How does this help if VARCHAR is the same as TEXT? – OneCricketeer Oct 27 '17 at 05:14
VARCHAR is not same as TEXT, TEXT is same as VARCHAR. TEXT is super class for VARCHAR – Lalit Jadav Oct 27 '17 at 05:15
There is no difference in what we said. There is no VARCHAR... Also, then documentation says *SQLite understands the column type of "VARCHAR(N)" to be the same as "TEXT"* – OneCricketeer Oct 27 '17 at 05:16
For portability with MySQL / PostgreSQL? I don't know. SQLite does not care about the value of N. – OneCricketeer Oct 27 '17 at 05:20
you can't choose a size for text but you can choose the size for varchar. Varchar is better to use for database optimization. – Oct 27 '17 at 05:24
1

android doesn't matter with size specified, as @cricket_007 says – Lalit Jadav Oct 27 '17 at 05:32

score 0 · Answer 2 · answered Oct 27 '17 at 05:54

0

add is a sqlite keyword. As such it cannot be used as an identifier such as a column name.

Rename that column to something that is not a keyword.

answered Oct 27 '17 at 05:54

laalto

150,114
66
286
303

hurree thankyou so much my misteck is that colum name is remane add is any key word – Jadav Ramesh Oct 27 '17 at 06:01

create table query are not perform in android connect to SQLite database

2 Answers2