Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scope_Identity
Message
From
08/03/2010 14:08:59
Derek Chapman
United Kingdom
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Scope_Identity
Environment versions
SQL Server:
SQL Server 2005
Application:
Desktop
Miscellaneous
Thread ID:
01453233
Message ID:
01453243
Views:
40
Hi

lnReturnCode = SQLExec(lnConnectionID, 'exec Candidate_Insert_Blank ?1000000001', '@lnCandidateID')

The 10000000001 parameter is the new record ID for the stored procedure insert, the lnCandidateID is the local VFP variable I want to fill with the return value from my stored procedure.

Regards
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform