开发者

SQLite: 2 Problems by working with table

开发者 https://www.devze.com 2023-01-03 12:32 出处:网络
Hallo all, I have a SQliteDatabase object db, i want to create a table in db with the following code db.execSQL(\"CREATE TABLE IF NOT EXISTS \"+ TABLE2_NAME + \" (exer_nr INTEGER PRIMARY KEY ,exerTe

Hallo all,

I have a SQliteDatabase object db, i want to create a table in db with the following code

db.execSQL("CREATE TABLE IF NOT EXISTS "+ TABLE2_NAME + " (exer_nr INTEGER PRIMARY KEY ,exerText       varch开发者_如何学Goar(250),answerA varchar(250),answerB varchar(250),answerC varchar(250),answerD varchar(250))");

An Error occur. Why? Is this too large? How can i fix it?

Another problem: I want to insert a row into the table, whose "exerText" column contains the following code as part of it's content.

main( )
{ int m=12, n=34;
printf("%d%d", m+ +,+ +n);
printf("%d%d\n",n+ +,+ +m);
}

An Error occur because of the "" and '' symbols in the code. How can i fix this problem ?

Thanks a lot


"CREATE TABLE IF NOT EXISTS" is sqlite3-only. Are you using sqlite2?


Check to see if the table name you're passing has an embedded space. In any event, it would be better to put square brackets around the table name and better still to use a parameter to pass in the table name.


Not sure about Android at all, but following your comments, maybe Android version of sqlite has a limit on the row size. To check this, change the columns' length from 250 to 50 and see if it works.

Regarding the insert, you can solve the problem by doubling the character you use for quoting the values. So if you need to insert quote_'_and_double_quote_"_end, you do either of two ways:

INSERT INTO TABLE test_table (mytext) VALUES ('quote_''_and_double_quote_"_end');
INSERT INTO TABLE test_table (mytext) VALUES ("quote_'_and_double_quote_""_end");
0

精彩评论

暂无评论...
验证码 换一张
取 消