Information générale
Catégorie:
Codage, syntaxe et commandes
>>>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement