int iwk is a globe variable,sql command is: update mydb set ml= case iwk>5 and score>80 when 1 then 1 else 0 end;
but command run failed,the reason is iwk varible not a sql variable, how can I convert globe variable to sql variable? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users