大家来看看我的动态sql 语句有什么问题?
dec{2} ldec_max,ldec_min,ldec_averate//最高分、最低分、平均分
string sqlstatement
sqlstatement = "select max(" + ls_kemu + "), min("+ls_kemu+"), aver("+ls_kemu+") from stu_score where classname=:+condition2
prepare sqlsa from :sqlstatement;
open dynamic my_cursor;
fetch my_cursor into :ldec_max,:ldec_min,:ldec_averate;
close my_cursor;
sle_max.text = string( ldec_max )
sle_min.text = string( ldec_min )
sle_aver.text= string(ldec_averate)
sqlstatement=" select count(*) from stu_score where stu_score.class_name=:"+condition2
prepare sqlsa from :sqlstatement;
open dynamic my_cursor;
fetch my_cursor into :renshu;
close my_cursor;
sle_renshu.text= string(renshu)
其中condition2为一字符串全局变量,是指具体的班级名称,