1 Reply Latest reply on Mar 22, 2002 3:40 AM by 152901

    Newbie Question, VB

    232759
      Hi All,

      I have a newbie question for you....

      I am using VB to access oracle via OLE and am having trouble adding records.

      I am doing basically the following...

      set oraDyna = oraDBA.createdynaset("select * from products",0)
      oraDyna.AddNew

      At that point when it runs I get the error...
      "OIP-O4117: Not an updatable set."

      What am I doing wrong here?

      Thanks
      Dean
        • 1. re:Newbie Question, VB
          152901
          Replace the Option of 0 which is Default with the Oracle Mode option so you can get an updatble recordset because your dynaset will have the ability to 'ReFetch' data. A better practice is to not use updatable recordsets but rather direct SQL calls via the OraDatabase.ExecuteSQL method of better employing the OraSQLStmt object.


          Good Luck,

          Zane E