Re: OO4O sequence problem

From: Lucyna Witkowska <ypwitkow_at_nospamcyf-kr.edu.pl>
Date: Tue, 23 Sep 2003 12:17:13 +0000 (UTC)
Message-ID: <bkpdk9$nqd$1@srv.cyf-kr.edu.pl>

Ludo Joris <ludo.joris_at_ua.ac.be> wrote:
> I have been using sequences for years without problems
> (Oracle Database 8.0.6, Oracle Client 7.3.4). After I
> upgraded to Oracle Client 9.2.0.1 I have a problem with
> all my database sequences accessed from my VB programs.

(...)

> In VB5 with OO4O:
> SQL = "SELECT SEQ_MAG_BON_NR.nextVAL FROM DUAL"
> Set ds = TDB.CreateDynaset(SQL, ORADYN_NOCACHE)

try ORADYN_READONLY

Greetings,
LW Received on Tue Sep 23 2003 - 07:17:13 CDT