query1.Close;
query1.SQL.Clear;
query1.SQL.Add(format('select * from teacherbasic'+''+'where tyear='+'''%s''',[edit33.text]));
query1.Open;
query1.Active:=true
query1.SQL.Clear;
query1.SQL.Add(format('select * from teacherbasic'+''+'where tyear='+'''%s''',[edit33.text]));
query1.Open;
query1.Active:=true
你用的是什么数据库?
query1.SQL.Clear;
query1.SQL.Add('select * from teacherbasic where (tyear='''+datetostr(edit33.text)''')');
query1.Open;
query1.SQL.Clear;
query1.SQL.Add('select * from teacherbasic where tyear=:Atyear');
query1.ParamByName('Atyear').AsString:=Trim(edit33.text);
query1.Open;
query1.SQL.Clear;
query1.SQL.Add('select * from teacherbasic where tyear like ''%'+edit33.text+'''');
query1.Open;
query1.SQL.Clear;
query1.SQL.Add('select * from teacherbasic where tyear='''+edit1.text+'''');
query1.Open;
不是就行了吗???
因为select语句显示的是一条一条的记录,而你的写法只能显示出第一条记录,
也就是说:
format('第一条记录','[edit33.text]);
那怎么可能对呢,
你可以按照我上面的写法写