Re: better interface for queries?

Hi Uwe,

> Is there any possibilities to improve  the interface for queries,
> I   just have   in  mind  very  simple commands   like adding and
> multiplying columns.   While in scal  there  is a interface which
> helps me to do this in the  query I had more  or less to do trial
> and error to find out field1+field2 works, any kind of interface,
> in the line of the scal interface,  would be very helpful. But is
> this difficult to implement?

It would definately be possible (and in fact a Nice To Have (TM) thing).
"Difficult" depends on how much we would want to achieve with this. The
main problem here would be that OOo can work with arbitrary databases,
and different databases have different capabilities. This means the
query design user interface has to adjust itself to the capabilities of
the underlying database, and this might be the difficult part.

(Technically, OOo uses an abstract API to communicate with databases,
and there's only rather rudimentary support to ask a given - unknown -
database which expressions it supports.)

Ciao
Frank

-- 
- Frank Schönheit, Software Engineer         [email protected] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Database                   http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -