create trigger upd_test before update on [test]
for each row
begin
     select case when new.param >= (select max(id) from test) then
                 raise(ABORT, 'Param field is wrong')            
            end;
end

create trigger upd_test before update on [test]
for each row when new.param >= (select max(id) from test)
begin
     select raise(ABORT, 'Param field is wrong');           
end