Results 1 to 12 of 12

Thread: Cursors

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Question Unanswered: mistake

    nevermind forget I asked thanks anyways
    Last edited by desireemm; 01-14-05 at 15:47.

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    D,
    As a rule due to the processor intensive nature of cursors I only use them when the logic of what I am trying to do gets too complicated to do with general SQL.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Feb 2004
    Posts
    492
    What I've seen so far is that the 'the experts' tend to avoid cursors because it's usually slower than a regular select-statement.

    I'm not sure what you're asking about using "it as a filter", I suppose a regular select can be just as usefull as a cursor when it comes to filtering out data (it's all in the where-clause anyway). Could you be more specific what you mean with 'filter'?

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by desireemm
    I have two questions guys, I need more information on how to have a cursor fetch data for me...I was wondering if I can use it as a filter or something?? Or a Fast Forward Cursor with AutoFetch. I am reading about these two now to try and understand them better but I was hoping to get some advice from the experts as well??

    Thanks Guys

    What are you trying to do?

    99% of the time you don't need a cursor.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Ok thanks guys

    Nevermind thanks anways
    Last edited by desireemm; 01-14-05 at 15:49.

  6. #6
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    nevermind on the Cursor

    Nevermind about the Cursor guys....bad idea..sorry

  7. #7
    Join Date
    Feb 2004
    Posts
    492
    it's the consideration that counts...

  8. #8
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    filter

    Code:
    SELECT DISTINCT [FirstName],[TM#],[LastName],[SSN#]from qrySearchCriteriaSub WHERE 1=1
    Going into the Form Properties and and putting this inside record source
    Last edited by desireemm; 01-14-05 at 14:18.

  9. #9
    Join Date
    Feb 2004
    Posts
    492
    erh.. no.

  10. #10
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Advanced Filter

    Nevermind guys thanks anways
    Last edited by desireemm; 01-14-05 at 15:48.

  11. #11
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Success

    I got it now guys thanks anyways..well nevermind I helped myself..LOL

  12. #12
    Join Date
    Oct 2003
    Posts
    232

    Talking

    cursors are a great way to get query specifically from multitable
    Resource usage is more is true but tell me how many people use their database CPU at say over 90% ?
    bigfoots

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •