Cursor Question.

From: Phill (wackyphill_at_yahoo.com)
Date: 07/19/04

  • Next message: ThomasLL: "Actual Problem - bRE: #Deletein PostgreSQL ODBC connection..." 
    Date: 19 Jul 2004 13:20:44 -0700

    Can someone explain to me the purpose of the cursor library that you
    can use w/ ODBC?

    If it can only use static cursors that only scroll forward what is the
    point? I thought for scrolling to be practical it needed to go forward
    and back. Otherwise why wouldn't you just call Fetch a bunch of times
    yourself?

    What would be the reason for using it?

    I'm trying to learn cursors at the moment and I'm probably just not
    understanding something.

    Thanks.

  • Next message: ThomasLL: "Actual Problem - bRE: #Deletein PostgreSQL ODBC connection..."

    Relevant Pages

    • Re: Difference between insensitive and fast-forward cursors.
      ... Insensitive cursors make a copy of the data in tempdb, ... but can scroll around the data set. ... Fast-forward. ... Wayne Snyder, MCDBA, SQL Server MVP ...
      (microsoft.public.sqlserver.programming)
    • Re: SQL Server connectivity
      ... I feel like it must be something with the location of the cursors. ... table connection is probably using CLIENT side cursors. ... required by ODBC framework). ... > The problem is that the SQL server was moved to another office and a VPN ...
      (microsoft.public.data.ado)
    • Re: SQL Server connectivity
      ... It has been always my practice to set the recordset cursor to client side. ... > I feel like it must be something with the location of the cursors. ... > table connection is probably using CLIENT side cursors. ... > required by ODBC framework). ...
      (microsoft.public.data.ado)
    • Re: Cursors: Can this DBI::Oracle code be converted to DBI::OCDB?
      ... my $sth1 = $dbh->prepare(q{ ... my $sth2; ... allowance for cursors in the ODBC because of the odbc_cursortype => ... So if some one can give me the correct syntax for binding an ODBC ...
      (perl.dbi.users)
    • Re: Fujitsu cobol and SQLServer
      ... I think from googling that I need to tell the odbc driver to use server ... Server side cursors with SQL Server are not a good idea and are best ... EXEC SQL ... Fujitsu assumes last connection until/unless you use SET CONNECTION. ...
      (comp.lang.cobol)