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