General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
The issue is that when I run that stored procedure, from VFP, no record is being inserted into the table and no value is being returned to VFP.
The native VFP command is:
lnReturnCode = SQLExec(lnConnectionID, 'exec Candidate_Insert_Blank ?1000000001', '@lnCandidateID')
I know the stored procedure works, as does the VFP code, as if I removed the line 'set @CandidateID = cast(scope_identity() as int)' from my stored procedure then a new record is added as normal.
Regards
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