OO4OLE on 8.1.7 errors?

Hello,

I experience some weird problems with the latest release of OO4O or OO4OLE (Oracle Objects for OLE). I was wondering if people have similar experiences.

I have code that ran fine for the last couple of years against Oracle 7 and 8.0 and 8.1.5 and 8.1.6 databases. Now with 8.1.7 I get some daft errors. I traced one through to be a bug on the Update property of a dynaset. It seems to always be set to False. Not very helpful.

My original code was something like this: dynaset = db.dbcreatedynaset("select col1, col2 from table where rownum < 1", 0&)
if dynaset.Updatable = False then

    inform the user
end if

In this code Updatable is always False. I even let the user create a test table and do the test on that to prevent funny privilege errors or errors with views.

From the release notes of OO4O for 8.1.7 I read about some problems with dynsets behind the control. They recommend to do a movelast before referring to updatable etc. That sometimes seems to get me out of trouble but not always.

Is there anyone out there that uses Updatable? Please try it for me and report to gjlinker_at_oraxcel.com and/or back to the groups.

Kind regards, Gerrit-Jan Linker Received on Sat Mar 31 2001 - 12:45:07 CST