我要多个条件过滤,可程序老说用法错误,具体离子如下:
with table1 do
begin
open;
filted:=true;
filiter :=( '字段一='+''''+a+'''')and('字段二='+''''+b+'''');
filted := false;
end;
其中a,b为变量,程序提示过滤形式错误
with table1 do
begin
open;
filted:=true;
filiter :=( '字段一='+''''+a+'''')and('字段二='+''''+b+'''');
filted := false;
end;
其中a,b为变量,程序提示过滤形式错误
a, b: string;
begin
A := 'Chile';
b := 'Santiago';
with table1 do
begin
Open;
filtered:=false;
filter := 'Name='+ '''' + a +'''' +' and Capital='+ '''' + b +'''';
filtered := true;
end;
end;
filter := 'Name=''' + a +''' and Capital=''' + b +'''';