>Dilema over, I now have the routine working as expected
>
>My VFP code looks like:
>
>lnReturnCode = SQLExec(lnConnectionID, 'exec Candidate_Insert_Blank ?1000000001, ?@lnCandidateID', '')
>
>My SQL Server code looks like:
>
>ALTER procedure [dbo].[Candidate_Insert_Blank] (@CreatedByID int, @lnCandidateID int output)
>
>as
>begin
> set nocount on;
> insert into Candidate (CreatedByID)
> values (@CreatedByID)
> set @lnCandidateID = scope_identity()
>end
That's exactly what I suggested and that was the syntax used in the referenced threads as well.
If it's not broken, fix it until it is.
My Blog