>>>I think what Dave Emerson says is the solution, I haven't met this problem, because I always try to create the cursor with the SELECT .... WHERE... statement and run report on that cursor.
>>>
>>>Nick
>>
>>Nick,
>>
>>I agree. I finding more and more that using cursors for reports solves problems before they hit you in the face.
>>
>>Dave
>
>Just out of curiousity.... are you saying maybe that you prefer using cursors for reports over views? Or just prefer using cursors over the actual tables?

Roxanne,

In my case I prefer cursors over tables. If views are availble, they are preferred. I have several applications in which the user can create an ad hoc query selecting the fields he/she wants to see. In these I use cursors.

Dave