Oracle 8, ODBC 8.0.4.4.0, VB 5.0 problem, insert problem:

From: Colleen L Geislinger <colleen.l.geislinger_at_frb.gov>
Date: Fri, 26 Jun 1998 18:41:04 -0400
Message-ID: <3594237F.D70BFD3E@frb.gov>

Running Oracle 8, VB 5.0, Oracle ODBC driver 8.0.4.4.0. We are having problems with rdOpenDynamic as resultset type. We always get a rdOpenStatic resultset which cannot be used for inserts. Has anyone else had this problem??? There are primary keys on the table. Is there a workaround....

   Set mrdoEnv = rdoEnvironments(0)
   mrdoEnv.CursorDriver = rdUseOdbc
   Set mrdoConn = mrdoEnv.OpenConnection("XXXXXX", _

      rdDriverNoPrompt, False, "DSN=XXXX;UID=XXXXX;PWD=XXXXX")

   sSQL = _

      "SELECT fo_name, fo_dr_name_fk, fo_ca_name_fk, fo_fi_name_fk " _


      & "FROM folder_test " _


      & "WHERE fo_fi_name_fk = 'FOIA' " _


      & "ORDER BY fo_ca_name_fk, fo_dr_name_fk, fo_name ASC;"



   Set mrdoRS = mrdoConn.OpenResultset(sSQL, _
      rdOpenDynamic, rdConcurRowVer, 0) ' - Even though I say use

rdOpenDynamic as
'resultset type, I get a rdOpenStatic resultset. I do have a primary key defined on the table.

   mrdoRS.MoveFirst
   SetRecNum

   DataLoad

End Sub Received on Fri Jun 26 1998 - 17:41:04 CDT