with DataModuleManage.ADOQueryPub1 do begin Close; SQL.Clear; Parameters.Clear; Parameters.AddParameter.Name := 'p1'; Parameters.ParamValues['p1'] := fatherid; strSQL := 'select count(*) as a from dep_info where fdep_id =:p1'; SQL.Add(strSQL); Open; result := FieldByName('a').AsInteger; end;
ado.Parameters.Clear; ado.Parameters.AddParameter.Name :='test';
ado.Parameters.ParamByName('BudgetID').Value :='uValue';
begin
Close;
SQL.Clear;
Parameters.Clear;
Parameters.AddParameter.Name := 'p1';
Parameters.ParamValues['p1'] := fatherid;
strSQL := 'select count(*) as a from dep_info where fdep_id =:p1';
SQL.Add(strSQL);
Open;
result := FieldByName('a').AsInteger;
end;