OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

CLOSED: No Group By in views using HSQL

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
francesco1964
Newbie
Newbie


Joined: 21 Oct 2008
Posts: 3
Location: Venice - Italy

PostPosted: Tue Oct 21, 2008 10:27 pm    Post subject: CLOSED: No Group By in views using HSQL Reply with quote

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


Last edited by francesco1964 on Fri Oct 24, 2008 11:12 am; edited 1 time in total
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Wed Oct 22, 2008 2:45 am    Post subject: Reply with quote

hello

Maybe this link give you a solution

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

Romke
Back to top
View user's profile Send private message
francesco1964
Newbie
Newbie


Joined: 21 Oct 2008
Posts: 3
Location: Venice - Italy

PostPosted: Wed Oct 22, 2008 11:49 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Thu Oct 23, 2008 2:34 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
francesco1964
Newbie
Newbie


Joined: 21 Oct 2008
Posts: 3
Location: Venice - Italy

PostPosted: Thu Oct 23, 2008 11:06 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Fri Oct 24, 2008 1:47 am    Post subject: Reply with quote

Hello

Quote:

Are there some options to enable group by in the query wizard with HSQL?
AFAIK no

Quote:
Is it a bug?
maybe

Quote:
If so, how is the procedure to signal it to developers?
I don't know.
Maybe other people do know it.

with regards
Romke
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group