General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only