Automation error ?

Hvodan ser GetPractice metoden ud ?

Public Function GetPractice(ID, Title, Abstract, EmployeeNo, CreationDate, CompanyID, StatusID, EditorNo, EditorCompanyID, BestPractice, BestPracticeDate, Price)
    envVidenNet.spGetPractice ID, Title, Abstract, EmployeeNo, CreationDate, CompanyID, StatusID, EditorNo, EditorCompanyID, BestPractice, BestPracticeDate, Price
End Function

og spén

Alter Procedure spGetPractice
(
  @ID int,
  @Title varchar(100) OUTPUT,
  @Abstract varchar(500) OUTPUT,
  @EmployeeNo varchar(11) OUTPUT,
  @CreationDate DateTime OUTPUT,
  @CompanyID varchar(2) OUTPUT,
  @StatusID int OUTPUT,
  @EditorNo varchar(11) OUTPUT,
  @EditorCompanyID varchar(2) OUTPUT,
  @BestPractice bit OUTPUT,
  @BestPracticeDate datetime OUTPUT,
  @Price varchar(500) OUTPUT
)
As
SELECT @Title = Title, @Abstract = Abstract, @EmployeeNo = EmployeeNo, @CreationDate = CreationDate, @CompanyID = CompanyID, @StatusID = StatusID, @EditorNo = EditorNo, @EditorCompanyID = EditorCompanyID, @BestPractice = BestPractice, @BestPracticeDate = BestPracticeDate, @Price = Price
FROM tblGoodPractice
WHERE ID = @ID

problemet er løst det var nogle parametersettings, som var sat forkert.

output pararmetre var sat til input/output i stedet for output.