<div id="RTEContent"> I need to test each record of a cursor for some requirements, something like this<br /><br />
DECLARExpvnr varchar(50);<br /> xdata date;<br /> xcod int;<br /> xagentd varchar(3);<br /> xid
bigint;<br/> xserie varchar(4);<br /> xnr varchar(7);<br /> xsocasig varchar(3);<br /> DECLARE myCursor
CURSORFOR<br /> select cod,pvnr,data,agentd,id,serie,nr,socasig <br /> from pvmst, pvdtl<br /> where
pvmst.cod=pvdtl.cod<br/> order by data;<br /> BEGIN<br /> delete from stoccalc_temp;<br /> OPEN myCursor;<br />
FETCHNEXT FROM myCursor INTO xcod,xpvnr,xdata,xagentd,xid,xserie,xnr, <div id="intelliTxt" name="intelliTxt"><wbr
/>xsocasig; <br />WH ILE (still in the cursor)<br /> BEGIN<br /> DECLARE<br /> xxcod varchar(21);<br
/> xxcod2 varchar(21);<br /> xxagent varchar(3);<br /> xxid bigint;<br /> DECLARE
my2cursorCURSOR FOR<br /> select cod,agent,id from stoccalc_temp <br /> where nr=xnr and serie=xserie
andsocasig=xsocasig;<br /> OPEN my2cursor;<br /> FETCH NEXT FROM my2cursor INTO
xxcod,xxagent,xxid;<br/> xxcod2:=TRIM('2005'+TRIM(xsocasig)+TRIM(<wbr />xxagent)+T<wbr />RIM(xserie<wbr
/>)+TRIM(xnr<wbr/>));<br /> IF xxcod <> '' THEN -- inseamna ca este in stoccalc_temp polita<br />
updatestoccalc set cod=xxcod2, agent=xxagent, stare='0' where id=xid;<br /> END IF;<br /> CLOSE
my2cursor;<br/> FETCH NEXT FROM myCursor INTO xcod,xpvnr,xdata,xagentd,xid,xserie,xnr,<wbr />xsocasig;<br
/> END;<br/>CLOSE myCursor;<br />END;</div><br /> -- the problem is that I do not know how to make the while loop
executeuntil the last record "WHILE (still in the cursor)"... So I need something like <br /><br /> for i:=1 to
lastrecord_of_cursordo<br /> begin<br /> ...<br /> end; <br /><br /> Can anyone help me with this? It really seems
silly...but I cannot get to solve this, I do not know where to look for syntax like this or tutorials like this.<br />
Help<br /></div><p><hr size="1" />Yahoo! Shopping<br /> Find Great Deals on Holiday Gifts at <a
href="http://us.rd.yahoo.com/mail_us/footer/shopping/*http://shopping.yahoo.com/;_ylc=X3oDMTE2bzVzaHJtBF9TAzk1OTQ5NjM2BHNlYwNtYWlsdGFnBHNsawNob2xpZGF5LTA1
">Yahoo! Shopping</a>