Android SQLiteopen Database connection causing exception

Question

03-12 16:56:25.652: E/Database(334): Failure 1 (near "tablefriends": syntax error) on 0x29b268 when preparing 'create tablefriends(_id integer primary key autoincrement,name text not null,address text);'.

I have debugged the code and found exception on 4th line of this given function:

public Boolean addFriend(FriendData friendData){

ContentValues newFriendValues=new ContentValues();
newFriendValues.put(FriendsMetaData.COLUMN_FRIEND_NAME, friendData.getFriend_Name());
newFriendValues.put(FriendsMetaData.COLUMN_ADDRESS,friendData.getFriend_Adress());

long id=friendsDB.insert(FriendsMetaData.TABLE_NAME, null, newFriendValues);
if(id==-1){
    return false;
}
else
    return true;    
}

Egor · Accepted Answer · 2012-03-12 20:35:17Z

1

Maybe you mean "create table friends", not "create tablefriends", that's why it throws the exception. Hope this helps.

answered Mar 12, 2012 at 20:35

Egor

40.3k11 gold badges117 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Android SQLiteopen Database connection causing exception

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related