Android database tables syntax errors
<p>I am trying to create a database with the name of a string stored in a local variable with the following syntax:</p>

<pre>
mDb.execSQL("CREATE TABLE " + FLASH_TABLE + " (" + KEY_CARD_ROWID
                + " INTEGER PRIMARY KEY AUTOINCREMENT, " + KEY_QUESTION
                + "TEXT NOT NULL," + KEY_ANSWER + "TEXT NOT NULL);");</pre>

<p>which produces the following error in log cat:</p>

<pre>
05-14 04:40:05.892: ERROR/Database(372): Failure 1 (near "15": syntax error) on 0x272140 when preparing 'CREATE TABLE 15 (_id INTEGER PRIMARY KEY AUTOINCREMENT, questionTEXT NOT NULL,answerTEXT NOT NULL);'.
</pre>

<p>with FLASH_TABLE being the local variable with the value "15"
KEY_QUESTION and KEY_ANSWER are also local variables</p>

<p>I have looked at every example online that I could find and I can not find the reason for the syntax error. I appreciate any advice you can offer.</p>
