UPDATE FORCES to READ THE TABLE AGAIN

From: Google User (geolocus_at_hotmail.com)
Date: 03/18/04

  • Next message: Andy Hassall: "RE: test_dynamic Error 29 installing DBD-Oracle v 1.15 on red hat 9 Oracle 9.2" 
    Date: 18 Mar 2004 07:25:46 -0800

    HI,

    Any one noticed behaviour of fetchrow_array.

    If I update the table while reading the table in the while loop, the
    update forces to read the table again. I get the same value that I
    fetched earlier.

    BTW: The executing is with transaction and SQL Server db

    For Eg:

    $sql = $cmd->prepare("SELECT (bla, bla FROM TABLE_X)");

    WHILE($sql->fetchrow_array)
    {
       "UPDATE TABLE_X SET bla=xxx";
    }

  • Next message: Andy Hassall: "RE: test_dynamic Error 29 installing DBD-Oracle v 1.15 on red hat 9 Oracle 9.2"