>>>However, I'm of the opinion that an ounce of prevention is really worth pounds of cure. If I'm pulling a cursor that is not going to be updated I will not add rewrite. select * from table nofilter gives me a readonly cursor. select * from table nofilter readwrite gives me a non-readonly cursor.
>>>
>>>If I should happen to issue a replace command against the readonly cursor, I've saved my sanity because the data could not affected.
>>
>>The READWRITE is sufficien by itself (it includes NOFILTER).
select * from mytable readwrite
>
>No because it means all cursors will be readwrite, when only some need to be readwrite.
Only cursors with READWRITE clause will be readwrite. The cursors with NOFILTER (w/o READWRITE ) will be read only.
--sb--