SQLITE insert into does not work.

See more:

SQLite

public Cursor GetTblShareTransactionSummary(DatabaseOperation dop, String TblMemberDetailId) {
       SQLiteDatabase sqLiteDatabase = dop.getReadableDatabase();
       String sqlQuery = "DELETE FROM TblShareTransactionSummary where TblMemberDetailId = " + TblMemberDetailId + ";" +
               "INSERT INTO TblShareTransactionSummary SELECT " + TblMemberDetailId + ", CompanyCode, '-','-','-','-','-','-' " +
               "FROM TblCompanyDetail order by CompanyCode ; " +
               "SELECT 1,CompanyCode,TotalShare,AverageRate,CurrentRate,InvestmentAmount,CurrentTotalAmount,Diff FROM TblShareTransactionSummary ;";

       return sqLiteDatabase.rawQuery(sqlQuery, null);
   }

What I have tried:

This is not working. Data is not inserted as well could not return any value. but there is values on

TblCompanyDetail 

.