Android Question SQLCipher probelm

[bixmatech]

Hi ...

I'm trying to use SQLCipher to protect my database , but I faced some problems.

this an example to my problem ..
http://www.mediafire.com/file/uyp5aibeznsore9/SQLCipher.rar

I used "DB Browser for SQLite" to create a database with one table.

when I try to do "SELECT * FROM table" , the application crash immediately

** Service (starter) Create **
** Service (starter) Start **
** Activity (main) Create, isFirst = true **
main_activity_create (java line: 356)
net.sqlcipher.database.SQLiteException: near "table": syntax error: , while compiling: SELECT * FROM table
    at net.sqlcipher.database.SQLiteCompiledSql.native_compile(Native Method)
    at net.sqlcipher.database.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:91)
    at net.sqlcipher.database.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:64)
    at net.sqlcipher.database.SQLiteProgram.<init>(SQLiteProgram.java:83)
    at net.sqlcipher.database.SQLiteQuery.<init>(SQLiteQuery.java:49)
    at net.sqlcipher.database.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:42)
    at net.sqlcipher.database.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1758)
    at net.sqlcipher.database.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1723)
    at anyhwheresoftware.b4a.objects.sqlcipher.SQLCipher.ExecQuery2(SQLCipher.java:196)
    at anyhwheresoftware.b4a.objects.sqlcipher.SQLCipher.ExecQuery(SQLCipher.java:183)
    at b4a.example.SQLCipher.main._activity_create(main.java:356)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:179)
    at b4a.example.SQLCipher.main.afterFirstLayout(main.java:102)
    at b4a.example.SQLCipher.main.access$000(main.java:17)
    at b4a.example.SQLCipher.main$WaitForLayout.run(main.java:80)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:158)
    at android.app.ActivityThread.main(ActivityThread.java:7225)
    at java.lang.reflect.Method.invoke(Native Method)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1230)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1120)

Note :
- I copied icudt46l.zip to Files folder
- Test it on Samsung Note 4 ( 6.0.1 )

Thank you

 

[fixit30]

I would guess table is a reserved keyword.

Try:

SELECT * FROM [table]

 

[bixmatech]

I would guess table is a reserved keyword.

Try:

SELECT * FROM [table]

it's worked , thank you so much