Problem with DbConnect.ExecN

Kirill_Trunov

I'm trying to add some data to my db table in Livelink db.

function Dynamic Execute( Dynamic ctxIn, Dynamic ctxOut, Record r )
   
    Dynamic DBconnect = r.prgCtx.fDBConnect    
   
    RecArray    ra = RecArray.Create( { 1, 2, 3, "gg" } )  
    execResult = DBconnect.ExecN("INSERT INTO  SomeTable (ObjID, VersionID, OwnerID, Txt_Data) VALUES (:A1,:A2,:A3,:A4)", ra)   
       
    if ( IsError( execResult ) )
      echo( 'An error occurred while updating the records' )   
    end
    return Undefined
end

SomeTable(MSSQL 2005) :

   ObjID - int field;

   VersionID- int field;

   OwnerID- int field;

   Txt_Data - ntext field;

But i recive execResult = 0 (0 rows added), after DBconnect.ExecN(...) and no Errors.

Keit Kivisild

Hi,

Try to turn on sql logging (opentext.ini -> wantlogs=true) and look at the connectionX.log.

regards,

keit