Re: ResultSetType Settings in Openoffice Base

Asli ,

You can change the settings using the API and a macro,  but you sould  
repeat your question on [email protected] where the developers can 
help you further.

Greetz

Fernand
> Hello,
>
> I am currently developing a DB project and I have implemented a database
> with IBM DB2 and connected it with jcc driver to Openoffice base. I had
> problems with "join queries of several tables". I searched in the source
> code of oo and in the internet, and I realized that the error arises from
> ResultSet settings, which are set to TYPE_SCROLL_SENSITIVE, default by
> openoffice. In order to display the results for a join query, resultSetType
> should be   TYPE_SCROLL_INSENSITIVE.
>
> I have found a log at :
> http://www.mail-archive.com/[email protected]/msg00858.html
> From what I understand, it is possible to update content.xml file, <
> db:data-source> part to set the result set type. Is it correct?
> If so, which xml element can be set to update resultsettype of the
> statement?
>
> I would be glad if you could help me. Thank you for all your help in
> advance.
>
> Regards,
> Asli
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>