Re: ADO and Oracle OLEDB 8.1.7.2.0

From: Zoran Rapajic <zoran.rapajic_at_zr.ev.co.yu>
Date: Tue, 18 Sep 2001 13:22:14 +0200
Message-ID: <9o7b2c$j96$1@Mercury.ev.co.yu>

• Original Message ----- From: "Volkhard Vogeler" <VolkhardV_at_Vogeler.com> Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools Sent: Wednesday, July 04, 2001 18:46 Subject: ADO and Oracle OLEDB 8.1.7.2.0

> Set objRS = CreateObject("adodb.recordset")
> objRS.CursorLocation = 2
> objRS.CursorType = adOpenStatic
> objRS.LockType = 3
> objRS.Open "select Name from testvvv", objConn
>
> objRS.AddNew arrFields, arrValues

Change this code...

objRS.CursorLocation = 2
objRS.CursorType = adOpenStatic
objRS.LockType = 3

Set objRS = CreateObject("adodb.recordset")

objRS.Open "select Name from testvvv", objConn

objRS.AddNew arrFields, arrValues

etc... Received on Tue Sep 18 2001 - 06:22:14 CDT