Posted by Ed Murphy on 08/03/07 02:15

walid kayrouz wrote:

> i have Been Declare a dynamic cursor to a query ==> select location_en from ...
> when i make update to the table, dynamic cursor take changes.
> when i declare same cursor with the query select distinct location_en ... and update to the table, dynamic cursor does not take changes.
> any idea to this probleme? thx for ur reply
>
> From http://www.google.com/search?hl=en&q="Dynamic+Cursor"+++"For+Select+Distinct"
>
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com

The standard advice for cursors is "avoid using them if at all
possible". Explain what you're currently doing with them, and the
gurus may be able to offer more specific answers.

[Back to original message]