Cursor loops?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Cursor loops?

  1. #1
    esch Guest

    Cursor loops?


    I have declared a cursor and am using it in a loop to check and perform actions
    on sertain elements within the cursor. I need to be able to skip over some
    processing and continue onto the next record. Can I do this by doing a fetch
    next inside the IF statement? Or, do I need to nest IF statements to get
    to the FETCH NEXT at the end of all the checks?

    any help would be appreciated...

    thanks.

  2. #2
    Paul Mc Guest

    Re: Cursor loops?


    G'day Esch.


    >I need to be able to skip over some
    >processing and continue onto the next record. Can I do this by doing a

    fetch
    >next inside the IF statement? Or, do I need to nest IF statements to get
    >to the FETCH NEXT at the end of all the checks?


    You can fetch inside your If... Best not to though. for maintenance and readibility.
    Better of nestingyour Ifs..

    Cheers,
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center