>>>>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.
Oh! I see what you meant. I don't need NOFILTER if I'm using READWRITE. Of course!