#21 Update field not cleared.

open-accepted
None
5
2008-03-11
2008-02-13
oorexxpert
No

Doing a PREPARE followed by multiple EXECUTES of UPDATE to an Oracle table results in fields contains residual data from previous update. Example:

sql_statement = 'UPDATE "TABLE" SET "VARCHARCOL" = ?' 'WHERE KEY = ?';
.
.
if sqlexecute("U1","CHAR","ABCDEF","CHAR",key1) < 0 then
call sql_error "Update U1";

if sqlexecute("U1","CHAR","XYZ","CHAR",key2) < 0 then
call sql_error "Update U1";

Results in record KEY2 having a value of "XYZDEF" for column VARCHARCOL.

Using rxsql24_odbc_w32 against Oracle database on Windows server.

By doing a OPEN, PREPARE, DISPOSE, CLOSE for each UPDATE, it works correctly.

John_bodoh@infrawise.com

Discussion

  • Mark Hessling

    Mark Hessling - 2008-03-11

    Logged In: YES
    user_id=86185
    Originator: NO

    I have confirmed this bug, and have determined the problem to be related to bind variables. Will fix ASAP.
    This bug is likely to affect all database drivers that allow bind variables.

     
  • Mark Hessling

    Mark Hessling - 2008-03-11
    • assigned_to: nobody --> rexx
    • status: open --> open-accepted
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks