[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]