i have a Sqlite problem in my tablet Android 4.0.3v;
Error:
07-28 14:28:18.495 6995-7125/com.titan.tablet E/AndroidRuntime﹕ FATAL EXCEPTION: Thread-544
android.database.sqlite.SQLiteException: near ",": syntax error: , while compiling: INSERT INTO tb_ingrediente ( ID_INGREDIENTE , DESCRICAO , ATIVO , UNIDADE ) VALUES
(1, 'CARNE', 1, 'UN'),
(2, 'QUEIJO', 1, 'UN'),
(3, 'PRESUNTO', 1, 'UN'),
(4, 'OVO', 1, 'UN'),
(5, 'FARINHA', 1, 'UN'),
(6, 'SALADA', 1, 'UN'),
(7, 'CEBOLA', 1, 'UN'),
(8, 'COCA-COLA 2L', 1, 'UN'),
(9, 'ÓLEO', 1, 'UN'),
(10, 'TOMATE', 1, 'UN');
In my Cellphone Android 4.1.2 this problema not happen.
Insert Code:
db.execSQL("INSERT INTO tb_ingrediente ( ID_INGREDIENTE , DESCRICAO , ATIVO , UNIDADE ) VALUES\n" +
"(1, 'CARNE', 1, 'UN'),\n" +
"(2, 'QUEIJO', 1, 'UN'),\n" +
"(3, 'PRESUNTO', 1, 'UN'),\n" +
"(4, 'OVO', 1, 'UN'),\n" +
"(5, 'FARINHA', 1, 'UN'),\n" +
"(6, 'SALADA', 1, 'UN'),\n" +
"(7, 'CEBOLA', 1, 'UN'),\n" +
"(8, 'COCA-COLA 2L', 1, 'UN'),\n" +
"(9, 'ÓLEO', 1, 'UN'),\n" +
"(10, 'TOMATE', 1, 'UN');" );
Could someone help me discover why the error only occurs in android 4.0.3?