Cześć mam taki trigger
AS
BEGIN
/* enter trigger code here */
if (exists (SELECT r.OBECNOSC FROM REJESTRACJA_NA_ZAWODY r
where ID_ZAWODY = 1 and
ID_CZLONKA_KOLA = 5 and OBECNOSC = 'T'))
then
insert into WYNIKI(ID,ID_CZLONKA_KOLA,ID_ZAWODY,WYNIK)
values(50,6,1,50);
END
Z ciekawości wykonałem takie zapytanie
INSERT INTO WYNIKI (ID, ID_CZLONKA_KOLA, ID_ZAWODY, WYNIK)
VALUES (
33,
5,
1,
100
);
Po czy dostaje
QL Message : -693
Too many concurrent executions of the same request
Engine Code : 335544663
Engine Message :
Too many concurrent executions of the same request
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger 'TEST2' line: 18, col: 9
At trigger '...
Jakieś sugestie :)?