Re: [sqlite] globe variable convert to sql

On Sun, Apr 15, 2012 at 9:19 PM, YAN HONG YE wrote: > 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

[sqlite] globe variable convert to sql

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? ___