Hi friend,
I have the following fucntion:
----------------------------------------------------------------------------------------
if exists(select 1 from sys.sysobjects where type = 'FR' and name = 'FnGenerateAnyCode')
begin
drop function FnGenerateAnyCode
end
go
create function FnGenerateAnyCode(@tableName varchar(100))
returns char(6)
as
begin
declare @incre int;
declare @currentValue int;
declare @startValue int;
declare @CodeFor varchar(100);
if exists (select 1 from sys.sysobjects where type = 'U' and name = @tableName )
begin
select
@incre = Increment,
@currentValue = CurrentValue from dbo.tblCodeGenerator
where CodeFor = @tableName
set @currentValue = @currentValue + @incre
update dbo.tblCodeGenerator
set CurrentValue = @currentValue
where CodeFor = @tableName
end
else
begin
set @incre = 1;
set @startValue = 1;
set @currentValue = 1;
set @CodeFor = @tableName
insert into tblCodeGenerator
values (@CodeFor, @startValue, @incre, @currentValue)
end
return @CurrentValue
end
go
when i run this i get this error:
Msg 443, Level 16, State 15, Procedure FnGenerateAnyCode, Line 21
Invalid use of side-effecting or time-dependent operator in 'UPDATE' within a function.
Msg 443, Level 16, State 15, Procedure FnGenerateAnyCode, Line 33
Invalid use of side-effecting or time-dependent operator in 'INSERT' within a function.
why do i get this error and how do i fix this?
thanks
