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

List:       koffice
Subject:    Re: Database integration in KWord
From:       Jaroslaw Staniek <js () iidea ! pl>
Date:       2007-11-14 17:49:29
Message-ID: 473B3529.8000409 () iidea ! pl
[Download RAW message or body]

Joerg Stadermann said the following, On 2007-11-14 15:32:

> I don't know if I would be up to the task, but to be honest I'm 
> not very interessted in kexi, which is certainly a very good 
> piece of software, but personally I'm more concerned about data 
> integration in environments with already existing database 
> backends.
> 
> I was thinking of a more simple way:
> 
> Click "Edit current entry"->displays tables
> Select a table->issues "select * from <table>"->displays records 
> in "Query result"-widget
> Select one or more records->constructs query->displays query in 
> query input field
> Click "Execute"->executes query
> 
> Still rather arward but you would have both: simple 
> point-and-click record selection and constructing more complex 
> queries by entering them directly in the text input. Additionally 
> you would cut one step for inserting database variables in your 
> document, since the selection of the table would already make the 
> fields available. 

Hello
As Thomas just mentioned, Kexi and KexiDB in particular is aimed at those tasks.
Feel free to do some research and start from scratch with native queries, 
_but_ note that your SQL statements will be specific to data-backend. This is 
normal once you use QtSQL. The queries are getting more specific as soon as 
you make them more complex.

Moreover, here's example: performing conversion of db data by hand, e.g. by 
simply populating tables with raw data converted to QString(), without 
koffice-level database drivers/providers is the pre-2004 state of Kexi project.

Joerg, optionally we can meet on #koffice irc channel as there are obvious 
misconceptions about what is possible to do and whether 'from scratch' 
approach is required.

I am curious whether you are interested in joining us in some way.

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org
____________________________________
koffice mailing list
koffice@kde.org
To unsubscribe please visit:
https://mail.kde.org/mailman/listinfo/koffice
[prev in list] [next in list] [prev in thread] [next in thread]