Re: cursors and transactions

the DELETEs will not close your cursor in any case (unless they crash your program! :-) Nicole Guffey wrote in message <6ubtnr$s$1@news.xmission.com>... >EX: >FOREACH select x into y from tableA >if not exists (select * from tablez where oid = y) >begin >delete tableb where oid = y >delete tablec where oid = y >delete tabled where oid = y >end >END FOREACH > a select cursor will close when "The cursor is a select cursor without >a HOLD >specification, and a transaction completes using COMMIT or ROLLBACK >statements." >Is this referring only to explicitly closed transactions, or will informix >treat each individual >delete as an implied transaction and close the cursor?