Android SQLite Query syntax error CREATE_TABLE

Question

I am not sure what is wrong with this query syntax but it just never works. My programming grabs all the correct info but fails at this point.

    public String CREATE_QUERY = "CREATE_TABLE "+ReceiptsTable.TableInformation.TABLE_NAME+"("+ReceiptsTable.TableInformation.RECEIPT_ID+" STRING,"+ReceiptsTable.TableInformation.RECEIPT_FILE+" STRING,"+ReceiptsTable.TableInformation.RECEIPT_URI+" STRING);";

Here is the error that it gives:

java.lang.RuntimeException: Failure delivering result ResultInfo{who=null, request=1, result=-1, data=null} to activity {com.example.section32point5.digiceit/com.example.section32point5.digiceit.CameraActivity}: android.database.sqlite.SQLiteException: near "CREATE_TABLE": syntax error (code 1): , while compiling: CREATE_TABLE receipts_table(receipt_ID STRING,receipt_FILE STRING,receipt_IMAGE STRING);

So to me, it finds the right names but cannot run it. Im guessing ive missed a colon or something.

Thanks in advance

EDIT: I just realised and don't understand why the first comment says:

D/Database operations: Table created

Then it says:

E/SQLiteLog: (1) near "CREATETABLE": syntax error

Because now you've made [another error](http://stackoverflow.com/questions/21881992/when-is-sqliteopenhelper-oncreate-onupgrade-run). — CL., Apr 17 '16 at 20:41
I don't understand. I just edited my post with the latest ive found. SQLite is not forgiving is it. One small space missed and your doomed. — MrAnderson1992, Apr 17 '16 at 20:59
Sorry, my initial comment was ambiguous. `CREATE` and `TABLE` are two separate words. You do need a space between them. — Mike M., Apr 18 '16 at 01:33
Excellent thank you very much. The table's are now created and the data inputs each time. Thanks Mike M. — MrAnderson1992, Apr 18 '16 at 19:21

score -1 · Answer 1 · answered Apr 18 '16 at 02:51

-1

Try this

public String CREATE_QUERY = " CREATE_TABLE " + ReceiptsTable.TableInformation.TABLE_NAME + " ( " + ReceiptsTable.TableInformation.RECEIPT_ID + " STRING, " + ReceiptsTable.TableInformation.RECEIPT_FILE + " STRING, " +ReceiptsTable.TableInformation.RECEIPT_URI + " STRING); ";

answered Apr 18 '16 at 02:51

Nguyễn Trung Hiếu

2,004
1
10
22

1

This is not correct. Please refer to the comments on the question. – Mike M. Apr 18 '16 at 10:40

Android SQLite Query syntax error CREATE_TABLE

1 Answers1