Hi Wolfgang,
you should use the com.sun.star.sdb.RowSet. This one can scroll even
when the underlying resultset is forward only.
It has his own cache. Therefore updates are only possible if the
underlying table has a primary key or the underlying resultset
is bookmarkable. The form is a csss.RowSet.
I hope this helps.
Best regards,
Ocke
Wolfgang Schaible wrote:
hi,
The object : com.sun.star.sdb.OResultSet
has the properties
ResultSetType long 1003 read-only
ResultSetConcurrency long 1007 read-only
Without a change of 'ResultSetType' to SCROLL_INSENSITIVE = 1004
there is no chance to scroll in the HSQLDB ...
and methods like 'previous' are without sense.
oResSet.ResultSetType=1004 -->read error. this Prop is ro
or
oResSet.setPropertyValue("SCROLL_INSENSITIVE", 1004) -->unknown Prop
exeption
but
in a form, created with the wizard, it is possible to move back and
forth..
How can I navigate?
Wolfgang
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Sachsenfeld 4 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Example isn't another way to teach,
it is the only way to teach.
Albert Einstein
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
