Re: Help, please

georget wrote: > > The matter is I'm confused with DECLARE CURSOR. > Before I've done the similar script with that without a problem. > Now when 7.2.3 version was installed on the RA Informix > doesn't want to understand DECLARE at all ;o( > The most interesting is I can't execute CURSOR on the old > machine("shadow") > Well, could you take a look on my script although I've checked it > carefuly > with Informix Manual or may be we gotta call in > Technical Supprot of Informix? > > Thanks in advance. > > P.S. The SQL server gives syntaxis error on "DECLARE" > > DECLARE login_cursor_id CURSOR FOR > SELECT login_code FROM cfg_agent_login FOR UPDATE OF dbid;> login_id INTEGER = 100; > log VARCHAR(32); > > OPEN login_cursor_id; > > WHILE EXISTS( > FETCH login_cursor_id INTO log; > EXIT WHEN login_cursor_id%NOTFOUND; > UPDATE cfg_agent_login SET dbid = login_id+1 > WHERE current of login_cursor_id;> login_id := login_id+1; > END WHILE; > > CLOSE login_cursor_id; > > -- > phone (415)437-1065 > fax (415)437-1260 > pager (415)207-9593 > georget-pager@genesyslab.com > <georget@genesyslab.com> Hi, I have no idea where there is a problem, but I had some problems with the trailing part "OF dbid" at the end of the cursor declaration. Try it with "... FOR UPDATE;". Bye Stefan