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
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
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
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 =
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
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"
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
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
8 matches
Mail list logo