Cursor

[Gast alexC++]

Hallo,

ich bräuchte mal eure Hilfe.

was bedeutet das FOR update of status

und das set nocount on in folgendem sql-befehl

declare #Cur cursor  for

select case when hi0.titulaire is null then '?' else hi0.titulaire end, 

hi0.sujet,hi0.date_deb,hi0.demande,hi0.so0_nrid,hi0.societe, hi0.var4, 

hi0.nrid, hi0.var51, hi0.var46, hi0.var129,

bActive  

from sysadm.hi0 hi0

left outer join sysadm.am0 am0 on am0.titulaire=hi0.titulaire

where var46 is not null

FOR update of status, ref, faitle, hi0.date_deb, ntype, hi0.var4, hi0.ntypeAction

Declare @NeuID varchar(30)

set nocount on

open #Cur

fetch next from #Cur into @titulaire,@Sujet, @date_Deb, @demande, @so0_nrid, @societe, @var4, @nrid, @var51, @Status, @var129, @BActive

while @@fetch_status = 0

Ok habe beides gefunden, sorry°!

Bearbeitet 17. November 2008 von alexC++