Android SQLiteException: near "(": syntax error (code 1):

Question

I've spend some time in try to fix this, but I don't know where is the problem in my sql create entries..

The error:

android.database.sqlite.SQLiteException: near "(": syntax error (code 1): , while compiling: CREATE VIRTUAL TABLE CommerceName ( _id TEXT  PRIMARY KEY,id INTEGER,name TEXT,category TEXT,imageref TEXT )

Thanks in advance

CODE:

 public static final String SQL_CREATE_ENTRIES =
            "CREATE VIRTUAL TABLE " + CommerceSearchReaderDbHelper.CommerceNameSearchEntry.TABLE_NAME + " ( " +
                    CommerceSearchReaderDbHelper.CommerceNameSearchEntry._ID            + TEXT_TYPE +"  PRIMARY KEY," +
                    CommerceSearchReaderDbHelper.CommerceNameSearchEntry.COLUMN_ID      + INTEGER_TYPE + COMMA_SEP +
                    CommerceSearchReaderDbHelper.CommerceNameSearchEntry.COLUMN_NAME    + TEXT_TYPE + COMMA_SEP  +
                    CommerceSearchReaderDbHelper.CommerceNameSearchEntry.COLUMN_CATEGORY+ TEXT_TYPE + COMMA_SEP  +
                    CommerceSearchReaderDbHelper.CommerceNameSearchEntry.COLUMN_IMAGEREF + TEXT_TYPE +
                    " )";

    public static final String SQL_DELETE_ENTRIES =
            "DROP TABLE IF EXISTS " + CommerceSearchReaderDbHelper.CommerceNameSearchEntry.TABLE_NAME;

    public static abstract class CommerceNameSearchEntry implements BaseColumns {
        public static final String TABLE_NAME       = "CommerceName";
        public static final String COLUMN_ID        = SearchManager.SUGGEST_COLUMN_INTENT_EXTRA_DATA;
        public static final String COLUMN_NAME      = SearchManager.SUGGEST_COLUMN_TEXT_1;
        public static final String COLUMN_CATEGORY  = SearchManager.SUGGEST_COLUMN_TEXT_2;
        public static final String COLUMN_IMAGEREF  = SearchManager.SUGGEST_COLUMN_ICON_1;
    }

Joshua · Accepted Answer · 2017-06-14 13:43:12Z

You are missing the spaces between your CommerceSearchReaderDbHelper.CommerceNameSearchEntry._ID and TEXT_TYPE, etc. Use this instead:

public static final String SQL_CREATE_ENTRIES =
            "CREATE VIRTUAL TABLE " + 
             CommerceSearchReaderDbHelper.CommerceNameSearchEntry.TABLE_NAME + " ( " + CommerceSearchReaderDbHelper.CommerceNameSearchEntry._ID          
             + " " + TEXT_TYPE +"  PRIMARY KEY," +
                    CommerceSearchReaderDbHelper.CommerceNameSearchEntry.COLUMN_ID + " " + INTEGER_TYPE + COMMA_SEP +
                    CommerceSearchReaderDbHelper.CommerceNameSearchEntry.COLUMN_NAME + " " + TEXT_TYPE + COMMA_SEP  +
                    CommerceSearchReaderDbHelper.CommerceNameSearchEntry.COLUMN_CATEGORY + " " + TEXT_TYPE + COMMA_SEP  +
                    CommerceSearchReaderDbHelper.CommerceNameSearchEntry.COLUMN_IMAGEREF + " " + TEXT_TYPE +
             " );";

Dave · Accepted Answer · 2017-06-14 14:06:56Z

1

If you really intend to create a virtual table, then you are missing "USING module_name". See here.

If you instead do not intend to create a virtual table (which is likely since you are using Android), then you should remove "VIRTUAL" from the CREATE statement. The syntax is here.

edited Jun 14, 2017 at 14:06

answered Jun 14, 2017 at 13:34

Dave

4,3112 gold badges21 silver badges24 bronze badges

3 Comments

S.P. Over a year ago

what do you mean with: missing "USING module_name

Dave Over a year ago

Virtual tables require a backing implementation. Since you have specified the Android tag, I would actually assume you do not intend to create a virtual table (since that is relatively complicated). More likely you intend to create a regular table. I will update the answer.

Dave Over a year ago

Also, if TEXT_TYPE and INTEGER_TYPE are not defined to include space(s) at the beginning, you may indeed have the problem hinted by the other answer once you sort out the CREATE syntax.

Collectives™ on Stack Overflow

Android SQLiteException: near "(": syntax error (code 1):

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related