CLOSED: No Group By in views using HSQL

[francesco1964]

Hi,

using HSQL the Group By options in Create View wizard and in other view tools is not enabled.

The documentation says that this option is enabled only if database supports the group by clause of SQL, but HSQLDB seems to support it, as said on it's site.

Why?

Thanks for any help.

Francesco

P.S. OpenOffice.org 2.4.1 on ubuntu gnu/linux

[RPG]

hello

Maybe this link give you a solution

http://www.oooforum.org/forum/viewtopic.phtml?t=62898&highlight=java+activate

Romke

[francesco1964]

Thanks for replay.

I have followed the istructions reportes at http://www.oooforum.org/forum/viewtopic.phtml?t=62898&highlight=java+activate, but nothing changes.

In my case java was already activated even if there was not a selection of jre, Selecting a jre out of the 3 ones installed does not change.

In my case the query wizard starts, but the options for grouping are disabled.

So problem is still open.

[RPG]

hello

I think the normal query design is as easy to use as the wizard.

And you are right it seem not to work

Romke

[francesco1964]

Hi,

I've tryed to write a SQL group by query by hand, and it works!

Example:
select Country, count(Country) from Employee group by Country

So HSQL confirms to support group by.

But this also confirms the bug in OpenOffice Base, the group by options in Create View Wizard are wrongly disabled.

I have found this link http://plan-b-for-openoffice.org/base/topic/new-query-using-wizard#screencast where you can see that also in a Windows installation the group by clause is disabled on wizard.

I would like to renew my request counting on your help.

Are there some options to enable group by in the query wizard with HSQL?
Is it a bug? If so, how is the procedure to signal it to developers?

Thanks to all.

[RPG]

Hello