Android Question MySQL Insert Error

there is no field with the name field3 in the table

Isn't it should be written as follow?
INSERT INTO tablename (field1, field2, field3, field4, field5) VALUES (?, ?, ?, ?, ?)

aeric said:

Isn't it should be written as follow?
INSERT INTO tablename (field1, field2, field3, field4, field5) VALUES (?, ?, ?, ?, ?)

Click to expand...

There is NO SUCH field field1 in the Table!
Even if you are correct about the corrected syntax.

Sorry, there was a typo of the insert statement above. It should be INSERT INTO ([field1], [field2], [field3], [field4], [field5]) Value (?, ?, ?, ? ,?).
I had checked the table creation. It's fined. But somehow even I rename the table or field name it's still gave the insert error.

Can I suggest you post the actual segment of code for your program as the insert statement you have put in that last post is still missing the table name.

Another suggestion I have is to test your insert statement in another program.
Because of subtle differences between different databases (MySQL / SQLite / Oracle / MSAccess/ etc) I tend to write and test any sql code in the actual database environment and copy/paste the result into my final program.

Once I have tested that it works I can then substitute the final values with the variables and include it in my final project and that way I have I high certainty that the code will work.
That approach also means I do not have to go through the cycle of - code / compile / release / test / fail / re-code / .......
Again, just a suggestion.