In short, it doesn't work.

Here's the complete VFP code:

lcParam1 = 'TestPC'
lnID = 0
=SQLExec(lnConnection, "execute ApplicationLoginInsert1 ?lcParam1, ?@lnID")

Here's the complete SQL code:

CREATE Procedure ApplicationLoginInsert1 @lcParam1 char(128), @ID int output
AS
insert into ApplicationLogin (Login_PC) values (@lcParam1)
declare @lnLoginID int
exec @lnLoginID = Version1.dbo.ApplicationLogin.Login_ID
SET @ID = @lnLoginID
GO

The record is inserted into the table correctly, however, no value is returned to VFP. Clearly something isn't right with the SQL code, but I have no idea where the mistake might be. Ideas?

Regards

Derek