My SQL Server stored procedure looks like:

ALTER procedure [dbo].[Candidate_Insert_Blank]
@CreatedByID int,
@lnCandidateID int output

as
begin
set nocount on;
insert into Candidate (CreatedByID)
values (@CreatedByID)
end

If I run that from VFP the insert will not take place, however, If I remove the line '@lnCandidateID int output' the insert will take place.