Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scope_Identity
Message
From
09/03/2010 02:33:41
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Environment versions
SQL Server:
SQL Server 2005
Application:
Desktop
Miscellaneous
Thread ID:
01453233
Message ID:
01453364
Views:
45
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform