Re: ERROR -266

Hi, I don't see an open for the cursor in your pseudocode. That could definitely cause a -266 "There is no current row for UPDATE/DELETE cursor" Let me know, Bill } } } Hi, } } I have this problem: } } ---------------------- } DECLARE p_cursor CURSOR WITH HOLD FOR select x from table_1 FOR = } UPDATE } } FOREACH p_cursor INTO variables } } SELECT * INTO variables_2 FROM table_2 WHERE variables .... } } IF variables_2 THEN } } UPDATE table_1 SET y =3D 0 WHERE CURRENT OF p_cursor } } END IF } } END FOREACH } -------------------- } } } When I run this program, ERROR -266 occurs } } Anyone have any idea? } } } Daniel Cernotto } DBA } Aguas Provinciales de Santa Fe } 1=B0 de Mayo 2832 - (3000) Santa Fe - Argentina } TE (54) 42 504110 } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net