Message d'erreur : "invalid cursor state"
j'ai un message d'erreur 'invalid cursor state' lors de l’exécution de mà requête :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
| DECLARE @MyCounter bigint
DECLARE @ActualWeightDIMS varchar(50)
DECLARE @MyI bigint
SET @MyI=1
SET @MyCounter =(SELECT top 1 (WAGENBARCODE) FROM CPS_VSWAGEN WHERE WAGENBARCODE like ''+PARAM1+'%' order by WAGENBARCODE DESC )
SET @MyCounter =@MyCounter+1
WHILE @MyI <= 10
BEGIN
SET @ActualWeightDIMS = 'Palette'+ cast(@MyCounter as varchar(20))
INSERT INTO CPS_VSWAGEN (WAGENBARCODE ,BEZEICHNUNG1 , ENTEREDBY ,ENTRYDATE, LASTUSER , LASTCHANGE, EDITUSER, EDITSTATUS,ANZAHLELEMENTE, EIGENTUEMER , STATUS, LIEFERANT )
VALUES ( @MyCounter ,@ActualWeightDIMS,1107 ,GETDATE(),1107 ,GETDATE() , 0 ,0 ,20 ,0 ,1 , 0 )
SET @MyCounter = @MyCounter + 1
SET @MyI = @MyI + 1
END; |
Je pense que ce message apparu
Code:
SET @MyCounter =(SELECT top 1 (WAGENBARCODE) FROM CPS_VSWAGEN WHERE WAGENBARCODE like ''+PARAM1+'%' order by WAGENBARCODE DESC )
merci de m'aider l’équipe
