Re: ResultSet ro?

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