Re: Oracle Objects for OLE: NOCACHE-Parameter

In article <3tno8k$rph_at_sparcserver.lrz-muenchen.de>, Mark Sandor <u7l11ai_at_sun1.lrz-muenchen.de> wrote:
>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)
Are you including ORACONST.TXT in you project?  --If not, ORADYN_NOCACHE may be defaulting to a random value.

Also, are you referencing the dyn.RecordCount property after opening a dynaset in no-cache mode?
 --This should forace a movelast but was not in the first release    the second release has fixed this.
There
> ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
>
>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 Tue Jul 11 1995 - 00:00:00 CEST