Re: [sqlite] two tables question

2012-04-09 Thread Igor Tandetnik
On 4/9/2012 9:12 PM, YAN HONG YE wrote: update dzhhq set dzhhq.mlevel= update dzhhq set mlevel=... case dzhhq.stkname=myref.stkname when 1 then 88 else 0 end; What's myref? Which row of which table is myref.stkname supposed to come from? You might be looking for something

[sqlite] two tables question

2012-04-09 Thread YAN HONG YE
update dzhhq set dzhhq.mlevel= case dzhhq.stkname=myref.stkname when 1 then 88 else 0 end; show error: Query Error: near ".": syntax error Unable to execute statement ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] case where sqlite3_prepare_v2 returns OK and sets stmt to NULL

2012-04-09 Thread Black, Michael (IS)
You want your assert to be this: assert(stmt != NULL); Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org

[sqlite] case where sqlite3_prepare_v2 returns OK and sets stmt to NULL

2012-04-09 Thread Rafael Ávila de Espíndola
Is it expected that the following program should run without asserting? --- #include #include #include int main() { sqlite3 *db = NULL; int rc; rc = sqlite3_open("test.db", ); assert(rc == SQLITE_OK); assert(db); sqlite3_stmt *stmt = NULL; rc =

Re: [sqlite] undefined symbol: sqlite3_stricmp

2012-04-09 Thread Alexey Pechnikov
As I find is missed sqlite3_stricmp reference in file loadext.c -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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