Re: Problem with Dynasets in OO4O

Hi,

Does this happen with all your queries or just some? I know it's daft but we had a similar problem using ADO, for some reason the .EOF etc didn't work if the SELECt staement contained an outer join on a view. Go figure???

Chris

Richard Peat <Richard_at_calusari.demon.co.uk> wrote in message news:954858679.29374.0.nnrp-11.c2461ae1_at_news.demon.co.uk...
> Hi,
>
> 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
> 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.
> We have done a test in a basic VB application, not using MTS, and we get
the
> 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
> 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 Wed Apr 05 2000 - 15:12:44 CEST