这样写错了,帮我改一下
//department为dbcombobox组件
str:=department.text;
AdoDataSet2.CommandText := 'select * From employee where department='+str;
//department为dbcombobox组件
str:=department.text;
AdoDataSet2.CommandText := 'select * From employee where department='+str;
如果是。
str:=department.text;
AdoDataSet2.CommandText := 'select * From employee where department=' + chr(39)str+ chr(39);
AdoDataSet2.CommandText := 'select * From employee where department='+str;
AdoDataSet2.CommandText := 'select * From employee where department='''+str'''';
str:=Trim(department.text);
AdoDataSet2.CommandText := 'select * From employee '
+'where department='+QuotedStr(str)+';
2.如果str是数值型的,代码如下:
str := DepartMent.values;
AdoDataSet2.CommandText := 'select * From employee '
+'where department='+inttostr(str)+';
如果是字符类型的话则要在SQL语句中加单引号括起来。
str :='select * from employee where department='+#39+department.text+#39;
AdoDataSet2.CommandText := str;