procedure TMainForm.DataSetBroker2AfterPost(DataSet: TDataSet);
var
lQuery:TQuery;
begin
lQuery := TQuery.Create(nil);
begin
lQuery.ConnectionString :='Biz:\HGOPERATION\HGOPERATIONDB.DATABASE\XHP.Table';
lQuery.CommandText := 'SELECT count(1) From XHP Where '+' YJHX = ''0'' '+' and BH = :a';
lQuery.Params.ParamByName('a').AsString := DataSetBroker2.DataSet.FieldByName('BH').AsString;
lQuery.Open;
if lQuery.Fields[0].AsInteger > 0 then
begin
DataSetBroker1.DataSet.Edit;
DataSetBroker1.DataSet.FieldByName('YJHX').AsString:='02';
DataSetBroker1.DataSet.ApplyUpdates;
end
else
begin
DataSetBroker1.DataSet.Edit;
DataSetBroker1.DataSet.FieldByName('YJHX').AsString:='01';
DataSetBroker1.DataSet.ApplyUpdates;
end;
end;
lQuery.Free;
end;
这个错误怎么修改
procedure TMainForm.DataSetBroker2AfterPost(DataSet: TDataSet);
var
lQuery:TQuery;
begin
lQuery := TQuery.Create(nil);
begin
lQuery.ConnectionString :='Biz:\HGOPERATION\HGOPERATIONDB.DATABASE\XHP.Table';
lQuery.CommandText := 'SELECT count(1) From XHP Where '+' YJHX = ''0'' '+' and BH = :a';
lQuery.Params.ParamByName('a').AsString := DataSetBroker2.DataSet.FieldByName('BH').AsString;
lQuery.Open;
if lQuery.Fields[0].AsInteger > 0 then
begin
DataSetBroker1.DataSet.Edit;
DataSetBroker1.DataSet.FieldByName('YJHX').AsString:='02';
DataSetBroker1.DataSet.ApplyUpdates;
end
else
begin
DataSetBroker1.DataSet.Edit;
DataSetBroker1.DataSet.FieldByName('YJHX').AsString:='01';
DataSetBroker1.DataSet.ApplyUpdates;
end;
end;
lQuery.Free;
end;
这个错误怎么修改