有以下代码,可就是不能更新!请指点!
procedure TForm1.Button1Click(Sender: TObject);
begin
with query1 do
begin
close;
with SQL do
begin
clear;
add('update ds01.dbf');
add('set YHMC=''1''');
add('where CGBZ=''Y''');
end;
execSQL;
end;
end;
procedure TForm1.Button1Click(Sender: TObject);
begin
with query1 do
begin
close;
with SQL do
begin
clear;
add('update ds01.dbf');
add('set YHMC=''1''');
add('where CGBZ=''Y''');
end;
execSQL;
end;
end;
begin
with query1 do
begin
close;
with SQL do
begin
clear;
add('update ds01.dbf');
add('set YHMC=' + QuotedStr('1'));
add('where CGBZ=' + QuotedStr('Y'));
end;
execSQL;
end;
end;试试
update 后的表名应该是什么格式?我这样写有没有问题?如果ds01.dbf用table控件绑定了应该怎么样写呢?
begin
Close ;
SQL.Clear ;
SQL.Add('INSERT INTO "e:\11.dbf" VALUES(' + QuotedStr('aaaa') + ', 2)') ;
ExecSQL ;
end ;
我试过了,没问题!