Re: Delete from view_name where current of cursor name

You havent mentioned which version of Informix 4GL you are using but I suspect it is >= 6.x in which case you need to refer to the cursor as follows: DELETE FROM dilcf WHERE CURRENT OF cursor_name("cur_del") Another point is whether you can delete or update a VIEW that comprises of multiple tables. You have to check on that as well. Gopi. Vincent Legendre <vlegendre@g-t.fr> wrote in message news:7na2s8$db7$1@news.entreprises.cegetel.fr... > Hi, > > I can't delete record in a cursor. > > Example : > DECLARE cur_del CURSOR FOR > SELECT * FROM dilcf > WHERE ncdf = wecf.ncdf > AND cdos = wcdos > AND cdpo = w_anc_cdpo > FOR UPDATE > OPEN cur_del > FETCH cur_del INTO wlcf.* > WHILE SQLCA.SQLCODE = 0 > DELETE FROM dilcf WHERE CURRENT OF cur_del > FETCH cur_del INTO wlcf.* > END WHILE > CLOSE cur_del> > Results on instruction " DELETE FROM dilcf WHERE CURRENT OF cur_del " > => error -507 : cursor "cur_del" not found > > What could be the reasons? > > Notes : Table declaration "dilcf" is a view on a remote host > Dynamic server version 7.30 > > Thanks > > Vincent Legendre > >