CODEWITHSUNDEEP
androidandroid-sqlite
Slaiv206
Slaiv206

Reputation: 309

Put values in the same column

I have a problem when I try to put values in a column, this is my code:

        scelta.put(Codice.DATI_NOME_DIETA, "Scarsdale");
        scelta.put(Codice.DATI_NOME_DIETA, "Dieta Atkins");
        scelta.put(Codice.DATI_NOME_DIETA, "Dieta dissociata");
        scelta.put(Codice.DATI_NOME_DIETA, "Weight Watchers");
        scelta.put(Codice.DATI_NOME_DIETA, "Dieta Zona");
        scelta.put(Codice.DATI_NOME_DIETA, "La dieta Dukan");
        scelta.put(Codice.DATI_NOME_DIETA, "Cronodieta");

        db.insert(Codice.TABLE_SCELTA, null, scelta);

But when I print the table I see only the last value "Cronodieta" and not all the values.

Upvotes: 0

Views: 68

Answers (3)

Phantômaxx
Phantômaxx

Reputation: 38098

How would I do it: 

String[] values =
    "Scarsdale,Dieta Atkins,Dieta dissociata,Weight Watchers,Dieta Zona,La dieta Dukan,Cronodieta".split(",");

for(String value : values)
{
    scelta.put(Codice.DATI_NOME_DIETA, value);
    db.insert(Codice.TABLE_SCELTA, null, scelta);
}

Upvotes: 0

Sudarshan
Sudarshan

Reputation: 1291

@Slaiv206

See you are setting up different value on a same key name, so each time the value you written will be Overwritten. So use like below

String[] DATI_NOMES = {"Scarsdale","Dieta Atkins","Dieta dissociata",...,"Cronodieta"}

for(int i=0; i < DATI_NOMES.length;i++){

 scelta.put(Codice.DATI_NOME_DIETA, DATI_NOMES[i]);
 db.insert(Codice.TABLE_SCELTA, null, scelta);

}

Upvotes: 1

Surender Kumar
Surender Kumar

Reputation: 1123

You can make a loop in your activity and then calls the database insert function to add values : 

String[] s = {"a", "b",....};
for(int i=0; i<s.length;i++){
db.insert(s[i]);
}

Try it.

Upvotes: 0

Related Questions