Re: features of the intrinsic HSQL database: sum columns

Frank Schönheit - Sun Microsystems Germa ny <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Hi Uwe,

better late than never, I hope :)

> Since my difficulties with the mysql database via the odbc driver
> persist I thought of using the new HSQL database.
> 
> I don't need much mostly simple operations of columns, like summing
> multiplication etc. However it seems not to works at least not the way
> it worked with the mysql database, that is selecting in queries the
> sum of two numeric columns did not produce any reasonable result.
> 
> Could somebody please tell me what is the state of art of this
> database.

The *complete* state of the art can probably be found at
http://hsqldb.org, but sums and multiplications work like a charm for
me. What exactly is the problem?

Ciao
Frank

-- 
- Frank Schönheit, Software Engineer         [email protected] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Database                   http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.