Error Creating Table on Android?

Change auto_increment to autoincrement and you should be good. Simple syntax error :).

There are two problems in count INTEGER not null auto_increment as mentioned by smith324, auto_increment is spelled wrong more importantly, count has to be primary key, if you want to have it auto-increment by sqlite rules.

I'm creating an application to input input string values from EditText into a SQLite database. When running the app through the simulator, a logcat error message is received when the database will be created initially. The logcat error message is below.

01-23 16:47:39.613: E/Database(1386): Failure 1 (near "existinfoTable": syntax error) on 0x1392b8 when preparing 'create table if not existinfoTable(_idinterger primary key,sNametext not null,wUrltext not null,uNametext not null,pWordtext not null);'. The OnCreate method it is referring to is below. I'm not sure what syntax error is causing the problem.

Any help would be appreciated.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions