[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice
Subject:    Re: KOffice interfacing and formulars
From:       David Faure <david () mandrakesoft ! com>
Date:       2002-02-28 1:42:22
[Download RAW message or body]

On Tuesday 26 February 2002 12:51, Stefan Petersen wrote:
> Hi everybody,
> 
> at the moment I have StarOffice running with some forms and a connection to a \
> postgresql-database via ODBC to display the data's of the database. 
> Is this also possible with KOffice ?

There is no database application as part of KOffice yet.
Several have talked about starting one, but currently there's still nothing.
The only database-related feature in KOffice is KWord's mail merge which
(in CVS, not in 1.1.1) can take data from a database.
This uses Qt3's SQL-database support, which makes it very easy to access
all brands of SQL databases (hint! ;).

> I have read the documentattion and some tutorials regarding DCOP-interfacing. From \
> my understanding it should be possible to communicate e.g with Kspread via the \
> DCOP-interface. What kind of interfacing is supplied by the KOffice-Components ?

It has been much improved recently. You can see with "kdcop" the available \
interfaces, they allow you to edit the data in the document (e.g. the cells in \
KSpread) etc.

> I think it should be possible to make a database-connection via a C or C++ program \
> and send the data via the DCOP interface to any Koffice component to be displayed \
> in any way , isn't it ?

Yes - that'd be a very useful thing to setup.

> Is it possible to make some dialogs in a Koffice-document ?

Not with some kind of macro language, that's currently not available,
although some people are talking about how they want to implement that ;)
You'd need to make it C++, and part of the application.

I would suggest developing a C++ dialog/wizard that creates the SQL connection,
selects the query to get the data, and inserts the result into KSpread cells.
That means no DCOP nor scripting, but a builtin functionality that would be very
useful, I think.

-- 
David FAURE, david@mandrakesoft.com, faure@kde.org
http://people.mandrakesoft.com/~david/, http://www.konqueror.org/
KDE, Making The Future of Computing Available Today


[prev in list] [next in list] [prev in thread] [next in thread]