Re: [sqlite] how to update value of string

2012-04-09 Thread Petite Abeille
On Apr 9, 2012, at 10:49 AM, Petite Abeille wrote: > > On Apr 9, 2012, at 10:43 AM, YAN HONG YE wrote: > >> my sqlite database "db" have a column remarks text default "2012", I want to >> add string "high" to the string of remark as "2012high" when the score >80 >> >> and add string "middle"

Re: [sqlite] how to update value of string

2012-04-09 Thread Petite Abeille
On Apr 9, 2012, at 10:43 AM, YAN HONG YE wrote: > my sqlite database "db" have a column remarks text default "2012", I want to > add string "high" to the string of remark as "2012high" when the score >80 > > and add string "middle" to the string of remark as "2012middle" when the > score>60 an

[sqlite] how to update value of string

2012-04-09 Thread YAN HONG YE
my sqlite database "db" have a column remarks text default "2012", I want to add string "high" to the string of remark as "2012high" when the score >80 and add string "middle" to the string of remark as "2012middle" when the score>60 and score <80 update the db.remarks value strcat(remark,"hig