RE: Dynamic Cursor Generation..

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

Re: Dynamic Cursor Generation..

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.