Oracle Objects for OLE: NOCACHE-Parameter

From: Mark Sandor <u7l11ai_at_sun1.lrz-muenchen.de>
Date: 1995/07/09
Message-ID: <3tno8k$rph_at_sparcserver.lrz-muenchen.de>#1/1


Hi out there,

i've got a question concering Oracle Objects OLE for VB. I'm using VB 3.0 and always get GPF when I try to do the following:
...(other lines)
dim dy as object
set dy = oradb.dbcreateDynaset("SELECT * FROM table...", ORADYN_NOCACHE)

                                                       ^ ^ ^ ^ ^ ^ ^ ^ ^ ^

If I leave out the _NOCACHE-switch and insert 0 instead (default), all works fine. But as documented in the Online-Help, the NOCACHE allows you to open the Dynaset for a fast-access read with no possibilities to access previous rows. That's exactly the thing i want to do.

Any known work-arounds?

Thanx in advance
cu..Mark

u7l11ai_at_sun.lrz-muenchen.de Received on Sun Jul 09 1995 - 00:00:00 CEST

Original text of this message