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