vendredi 24 avril 2015

SQLITE Error E/SQLiteLog﹕ (1) near "monthly": syntax error

Hi i've been getting a SQL error that says E/SQLiteLog﹕ (1) near "monthly": syntax error

i believe it may have something todo with my create Table statement

  private static final String CREATE_TABLE2 = "CREATE TABLE " + TABLE_NAME2 + " (" + UID +
        " INTEGER PRIMARY KEY AUTOINCREMENT, " + POST_CODE + " VARCHAR(255)," + FIRST_LINE +
        " VARCHAR(255)," + TOWN + " VARCHAR(255)," + COUNTY + " VARCHAR(255)," + ROOM_NO +
        " INTEGER ," + ASKING_PRICE + " INTEGER ," + CURRENT_OFFER + " INTEGER ," + AGREED_PRICE +
        " INTEGER ," + AGENT_NAME + " VARCHAR(255)," + AGENT_PHO_NUM + " VARCHAR(255)," + ESTATE_AGENT_NAME +
        " VARCHAR(255), " + REFURB_COST + " VARCHAR(255), " + TIME_OF_APPOINTMENT + " VARCHAR(255), "
        + DONE_UP_VALUE + " INTEGER ," +WEEKLY_ROOM_RATE+ " INTEGER ," +EXPECTED_RENT + " INTEGER ," + MAX_OFFER + " INTEGER ,"
        + DISCOUNT_PERCENT + " DECIMAL(3,2) ," + LOAN_TO_VALUE + " DECIMAL(3,2) ,"+ MORTGAGE_Interest + "DECIMAL(3,2) ," +
        MAX_MORTGAGE + " INTEGER ," + DESPOSIT_NEEDED + " INTEGER ," + DESPOSIT_REPAYMENT_MONTHLY+ " INTEGER ," + REPAYMENT_ANNAUL + " INTEGER ,"
        +STAMP_DUTY_PER + " DECIMAL(3,2) ," + STAMP_DUTY_ACT + " INTEGER ," +INSURENCES+ " INTEGER ," + TOTAL_PURCHASE_COSTS +
        " INTEGER ," + TOTAL_MONEY_NEEDED + " INTEGER ," + MORTGAGE_REPAYMENT + " INTEGER ," +
        BILLS_UTILS + " INTEGER ," + TOTAL_COST_PER_MONTH + " INTEGER ," + TOTAL_REFURB_COST + " INTEGER ," + TOTAL_PROJECT_COST +
        " INTEGER ,"+ TOTAL_PROFIT + " INTEGER ,"+ RENTAL_PROFIT + " INTEGER);";

this is my insertData method for adding to my database

public long insertData2(String posCode, String firstLine, String town, String county, int roomNum,
                       int askingPrice, int currentOffer, int agreedPrice, String agentName,
                       String agentPhone, String estateAgentNam, int refurb, String Time, int doneUp,int expectedRent
                        , int weeklyRent, int maxOffer,double discountPercent, double LoanToValue,Double mortgageInterest
                        , int maxMOrtgage , int despositNeeded, int despositRepayment, int despositRepaymentAnnual, double stampDutyPer,
                       int stampDutyAct , int insurances, int totalPurchaseCost,int moneyNeeded, int mortgageRepayments,int billsUtils,
                       int costPerMonth, int refurbCost , int projectCost, int totalProfit, int rentProfit) {

    ContentValues contentValues = new ContentValues();
    contentValues.put(POST_CODE, posCode);
    contentValues.put(FIRST_LINE, firstLine);
    contentValues.put(TOWN, town);
    contentValues.put(COUNTY, county);
    contentValues.put(ROOM_NO, roomNum);
    contentValues.put(ASKING_PRICE, askingPrice);
    contentValues.put(CURRENT_OFFER, currentOffer);
    contentValues.put(AGREED_PRICE, agreedPrice);
    contentValues.put(AGENT_NAME, agentName);
    contentValues.put(AGENT_PHO_NUM, agentPhone);
    contentValues.put(ESTATE_AGENT_NAME, estateAgentNam);
    contentValues.put(REFURB_COST, refurb);
    contentValues.put(TIME_OF_APPOINTMENT, Time);
    contentValues.put(DONE_UP_VALUE,doneUp);
    contentValues.put(WEEKLY_ROOM_RATE,weeklyRent);
    contentValues.put(EXPECTED_RENT,expectedRent);
    contentValues.put(MAX_OFFER,maxOffer);
    contentValues.put(DISCOUNT_PERCENT,discountPercent);
    contentValues.put(LOAN_TO_VALUE,LoanToValue);
    contentValues.put(MORTGAGE_Interest,mortgageInterest);
    contentValues.put(MAX_MORTGAGE,maxMOrtgage);
    contentValues.put(DESPOSIT_NEEDED,despositNeeded);
    contentValues.put(DESPOSIT_REPAYMENT_MONTHLY,despositRepayment);
    contentValues.put(REPAYMENT_ANNAUL,despositRepaymentAnnual);
    contentValues.put(STAMP_DUTY_PER,stampDutyPer);
    contentValues.put(STAMP_DUTY_ACT,stampDutyAct);
    contentValues.put(INSURENCES,insurances);
    contentValues.put(TOTAL_PURCHASE_COSTS,totalPurchaseCost);
    contentValues.put(TOTAL_MONEY_NEEDED,moneyNeeded);
    contentValues.put(MORTGAGE_REPAYMENT,mortgageRepayments);
    contentValues.put(BILLS_UTILS,billsUtils);
    contentValues.put(TOTAL_COST_PER_MONTH,costPerMonth);
    contentValues.put(TOTAL_REFURB_COST,refurbCost);
    contentValues.put(TOTAL_PROJECT_COST,projectCost);
    contentValues.put(TOTAL_PROFIT,totalProfit);
    contentValues.put(RENTAL_PROFIT,rentProfit);




    long id = db.insert(TABLE_NAME2, null, contentValues);
    return id;


}

i've been looking at tutorials and checking online but i just can't seem to see where im going wrong can anyone please help?

Aucun commentaire:

Enregistrer un commentaire