procedure TForm1.TabSheet2Show(Sender: TObject);
var
i:integer;
begin
datamodule2.assemble.Active:=true;
combobox1.Items.Clear;
with datamodule2.assequery1 do
begin
sql.Clear;
sql.Add('select distinct OrderNo from product where flag="no"');
open;
first;
for i:=0 to recordcount-1 do
begin
combobox1.Items.Add(fieldbyname('OrderNo').AsString);
next;
end;
close;
end;
end;
编译到first;时出现错误:"Data type mismatch in criteria expression",怎么解决?谢谢!
var
i:integer;
begin
datamodule2.assemble.Active:=true;
combobox1.Items.Clear;
with datamodule2.assequery1 do
begin
sql.Clear;
sql.Add('select distinct OrderNo from product where flag="no"');
open;
first;
for i:=0 to recordcount-1 do
begin
combobox1.Items.Add(fieldbyname('OrderNo').AsString);
next;
end;
close;
end;
end;
编译到first;时出现错误:"Data type mismatch in criteria expression",怎么解决?谢谢!
改为'select distinct OrderNo from product where flag = '+ QuotedStr('no');
试试看看
sql.Add('select distinct OrderNo from product where flag=0');