myAdvStoredProcedure.Params.CreateParam(ftInteger, '@CustomerID', ptInput).AsInteger := 1111;
myAdvStoredProcedure.Execute; (I also tried myAdvStoredProcedure.Open);
Is get the error 'No value given for one or more required parameters'
But i only have one param..
I tried everything but i cannot find what i am doing wrong..
The stored procedure :
CREATE PROCEDURE [dbo].[GetCustomerTest]
@CustomerID INT
AS
BEGIN
-- Select the employee name based on the EmployeeID provided
SELECT Name
FROM Customer
WHERE ID = @CustomerID;
END;
GO