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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
