General information
Forum:
Microsoft SQL Server
Mike, here is the problem:
Here is the procedure and the procedure call. This is used to get a unique ID at the beginning of the application. Works with one user, add a second and it freezes on the SQLEXEC statement. Also, procedures works consistantly in Query Anazyler.
*- Fox Code
lnStartKey = 0
= SQLEXEC(oCMIS.ConHandle, '{CALL spGetKey(?@lnStartKey)}')
oCMIS.StartKey = lnStartKey
*- SQL Server Code
CREATE procedure spGetKey(
@retKey int = null output)
as
declare @lnKey int
set @lnKey = (select theKey from Keys)
set @lnKey = @lnKey + 1
update Keys set theKey = @lnKey
set @retKey = @lnKey
Any help would be appreciated.
Thanx,
Charlie
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