ResultSet type default to FORWARD_ONLY with mysql db ?

Hi,

A couple of us on the French prog list are running into problems with
cursor movements in ResultSets in OOo 1.1.4.

It seems that the default property type for a ResultSet when connecting
to a dBase db sets one of the SCROLL constants, since the
commands .previous, .isBeforeFirst, isAfterLast, .relative and .absolute
work, but when accessing a mysql ResultSet, the type seems to default to
FORWARD_ONLY.

Although I looked in the API, there doesn't appear to be any mention of
the default values const types that are available for certain dbs. Are
these types obtained from MetaData or are they statically assigned, i.e.
for mysql, statically assigned in the MyODBC driver ?

An example of something that works with dBase and not with mysql can be
seen in the Livre de Programmation de OpenOffice.org by Bernard Marcelly
and Laurent Godard, page 539-540 :

With resuQuery
execOK = .next
GoSub afficher
execOK = .previous
GoSub afficher
execOK = .last
GoSub afficher
execOK = .relative(-3)
GoSub afficher
execOK = .absolute(3)
GoSub afficher
myBkmark = .Bookmark
execOK = .relative(-9999)
GoSub afficher
execOK = .movetoBookmark(myBkmark)
GoSub afficher
execOK = .absolute(9999)
GoSub afficher
execOK .moveRelativetoBookmark(myBkmark, 3)
GoSubAfficher
Exit Sub

The GoSub merely gets some strings of data from the result set and
displays them in a message box.

The error message :

        RunTime Error Basic
        Exception
        Type : com.sun.star.sdbc.SQLException
        Message : Wrong fetchtype with FORWARD ONLY cursor 


Any ideas, hints or advice ?

Alex