Problem with Dynasets in OO4O

From: Richard Peat <Richard_at_calusari.demon.co.uk>
Date: Tue, 4 Apr 2000 15:30:39 +0100
Message-ID: <954858679.29374.0.nnrp-11.c2461ae1_at_news.demon.co.uk>



Hi,

[Quoted] We are trying to create MTS based COM objects to provide data to a web application from an Oracle 8.1.5 database. We are writing the COM objects in [Quoted] Visual Basic 6.

We have successfully constructed an object that accesses the database, and we can read data back, and also step through the dynaset using the move methods. However the EOF and BOF properties are always coming back as False. [Quoted] We have done a test in a basic VB application, not using MTS, and we get the [Quoted] same problem, the EOF and BOF properties are always False, even if we call MoveFirst or MoveLast.

The code we are using to create the dynaset is as below.

Is this a known bug in the latest version of OO4O, or are we doing something [Quoted] fundamentally wrong? Any help would be much appreciated.

Regards

Richard Peat

--

--------------------------------------------

"God created the world in six days.  On the seventh day he also decided to
create England...
just to try out his Practical Joke Weather Machine."


    Set mOraSession = CreateObject("OracleInProcServer.XOraSession")
    Set mOraDatabase = mOraSession.OpenDatabase(sDBName, sConnect, 16&)

    Set mdynBMUnit = mOraDatabase.CreateDynaset(msSelect, 4)
Received on Tue Apr 04 2000 - 16:30:39 CEST

Original text of this message