i am getting error while i try to add datas to this table

[shawn peter]

this is my table creation code.

	
	private static final String TABLE_SWAP = "shiftswap";
	private static final String KEY_REQ_MEMBER = "reqmember";
	private static final String KEY_RES_MEMBER = "resmember";
	private static final String KEY_REQ_DATE = "reqdate";
	private static final String KEY_RES_DATE = "resdate";
	private static final String KEY_MEMBER_RESPONSE = "memberres";
	private static final String KEY_PM_RESPONSE = "pmrespnse";
	
	private static String global = "";

	public DatabaseHandler(Context context) {
		super(context, DATABASE_NAME, null, DATABASE_VERSION);
	}

	// Creating Tables
	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO Auto-generated method stub
		
		 
		try {
			
			
			String CREATE_SWAP_TABLE = "CREATE TABLE " + TABLE_SWAP + "("
					+ KEY_RES_MEMBER + " TEXT," + KEY_REQ_MEMBER + " TEXT PRIMARY KEY,"
					+ KEY_REQ_DATE + " TEXT" +KEY_RES_DATE + " TEXT" + KEY_MEMBER_RESPONSE + " TEXT" + KEY_PM_RESPONSE + " TEXT" +")";
			
			
			db.execSQL(CREATE_SWAP_TABLE);
			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

this is insertion part

[code=java]
ContentValues values = new ContentValues();
			values.put(KEY_RES_MEMBER, swapreq.getRes_member()); 
			values.put(KEY_REQ_MEMBER, swapreq.getReq_member()); 
			values.put(KEY_REQ_DATE, swapreq.getReq_date()); 
			values.put(KEY_RES_DATE, swapreq.getRes_date()); 
			
			db.insert(TABLE_SWAP, null, values);
			db.close(); // Closing database connection

below is error.that means it doesn't create the table.

10-02 09:24:08.180: I/Database(576): sqlite returned: error code = 1, msg = no such table: shiftswap
10-02 09:24:08.310: E/Database(576): Error inserting reqmember=Aruna resmember=Kasun reqdate=20 resdate=25

[shawn peter]

i am still having issue.Why it doesn't create the table?

[shawn peter]

Its resolved now .I missed the , .