Re: Basic Questions

[Jaroslaw Staniek]

On Fri, 31 Jul 2020 at 22:25, Swarup  wrote:

>
>
> On 7/31/20 9:26 AM, Jaroslaw Staniek wrote:
>
>
>
> On Thu, 30 Jul 2020 at 23:26, Swarup  wrote:
>
>>
>>
>> On 7/30/20 5:02 PM, Jaroslaw Staniek wrote:
>>
>>
>>
>> On Thu, 30 Jul 2020 at 21:44, Swarup  wrote:
>>
>>>
>>>
>>> On 7/30/20 3:32 PM, Jaroslaw Staniek wrote:
>>>
>>>
>>>
>>> On Thu, 30 Jul 2020 at 17:38, Swarup  wrote:
>>>
 Hello

 1. I am using Kexi Version 3.1.0  in Ubuntu 19.04.

 2. I have very basic needs, such as the need to be able to add another
 column without erasing all my data, and the need to increase the number of
 characters allowed in a cell, without that change erasing all my data. As I
 understand, these things cannot be done in Version 3.1.0.

>>>
>>> Hello. Right. First step is to upgrade to 3.2.
>>>
>>> This topic can be studied here
>>> https://forum.kde.org/viewtopic.php?f=221&t=132264
>>>
>>>
 3. Is there a very easy, user friendly way to update to the latest
 version of Kexi?

>>>
>>> Always three ways as follows, whatever suits best:
>>>
>>> 1. Request an easy way from your distributor
>>> 2. Change the distributor
>>> 3. Install a Flatpak snapshot https://community.kde.org/Kexi/Snapshots
>>>
>>>
>>> There is no point in me upgrading to the laterst version, if that
>>> version doesn't have the feature of allowing me to add columns or increase
>>> the number of allowed characters in a cell without erasing the data.
>>>
>>>
 4. Otherwise, I would like to export my data from Kexi and migrate over
 to MS Access. I have been using Kexi for many, many years-- but these basic
 limitations have made my work impossible.

>>>
>>> I am sorry about that. The forum thread explains a bit the fact that
>>> these features mean larger endeavours so we need more contributors on board.
>>>
>>>

 5. I do not see any option in Kexi to export my data to say csv. This
 is an import option, but I do not see an export option. Where is the option
 to export my data?

>>>
>>> Users can export each table by right-clicking and exporting to a file.
>>>
>>>
>>> This does not work. Any time I right click and select to export to a
>>> file, kexi crashes and shuts down. I have seen this same problem reported
>>> by several other users in the Ubuntu forums.
>>>
>>
>> That may be the reason for upgrading...
>>
>>
>> Are you telling me that if I upgrade, then the export feature will work?
>>
>
> My opinion is that it works in 3.2.0 and I worked on this issue for 3.2.0.
> Natural thing: because the Ubuntu distributors are not part of the KEXI
> project, they give no guarantee about their binaries, there is no 100%
> guarantee how it will behave.
>
>
>> Or are you guessing that it *may* work?
>>
>> Before I start putting big effort (which is what I know it is going to
>> be, nothing with Kexi is straightforward), into upgrading, I want to know
>> positively if the export feature works dependably or not.
>>
>
> Upgrading is not straightforward due to the distribution's guidelines.
> This is why the Flatpak version of KEXI has been developed - to suit many
> distributions in one go. If all effort is put into distributing, there
> would be no time for new features or fix in KEXI. Alternative can be a paid
> download.
>
>
>>
>>> Because these are SQLite tables, users can also run apps like
>>> sqlitebrowser to export all tables in one go (File->Export->CSV).
>>>
>>> I am not a techy to start learning how to use apps like sqlitebrowser.
>>>
>>> I need to get my data out of kexi, and from what I am hearing from you
>>> thus far it sounds, unfortunately, like my data is trapped in kexi and
>>> unable to get out. Please provide me a simple solution that works to export
>>> my data from Kexi. This is urgently needed.
>>>
>>
>> There are ready to use tools, e.g.
>> https://sqliteviewer.com/blog/export-sqlite-to-access/
>> I hope it works for you.
>>
>>
>> On the link you gave me, they themselves are writing "This method
>> involves complicated procedure, which on going wrong can lead to loss of
>> data from the Sqlite database".
>>
>> I am really regretting that I got my whole database stuck in Kexi. I've
>> been using this since 2008 for the past 14 years, and now I wish to not
>> remain stuck in this format any longer which has so many limitations. It
>> should not be listed as the alternative to MS Access. The two cannot be
>> compared.
>>
>> If you are able to provide me some real support and guidance for how to
>> dependably get my data out of this program, I will be very grateful.
>>
>
> I am sorry to hear that the free support you received is insufficient. You
> can consider finding a paid support, which would be potentially comparable
> to MS Access - I guess email or phone support of MS Access isn't free.
>
> Regarding the migration back, you need general guidance for "how to get
> data from SQLite to MS Access".
> There is no way to migrate forms and reports using a program, ba

Re: Basic Questions

[Swarup]

  
  


On 7/31/20 9:26 AM, Jaroslaw Staniek
  wrote:


  
  

  
  



  On Thu, 30 Jul 2020 at
23:26, Swarup 
wrote:
  
  
 
  
  On 7/30/20 5:02 PM, Jaroslaw Staniek wrote:
  
  

  


  
  
  
On Thu, 30 Jul
  2020 at 21:44, Swarup 
  wrote:


   

On 7/30/20 3:32 PM, Jaroslaw Staniek wrote:


  

  
  



  On Thu,
30 Jul 2020 at 17:38, Swarup 
wrote:
  
  
 Hello
  
  1. I am using Kexi Version 3.1.0  in
  Ubuntu 19.04. 
  
  2. I have very basic needs, such as
  the need to be able to add another
  column without erasing all my data,
  and the need to increase the number of
  characters allowed in a cell, without
  that change erasing all my data. As I
  understand, these things cannot be
  done in Version 3.1.0.

  
  
  
  Hello.
Right. First step is to upgrade to 3.2. 
  
  
  This
topic can be studied here https://forum.kde.org/viewtopic.php?f=221&t=132264
  
  
  
 
  3. Is there a very easy, user friendly
  way to update to the latest version of
  Kexi?

  
  
  
  
Always
  three ways as follows, whatever suits
  best:

  
  1.
Request an easy way from your
distributor 
  2.
Change the distributor
  3.
Install a Flatpak snapshot https://community.kde.org/Kexi/Snapshots

  


There is no point in me upgrading to the laterst
version, if that version doesn't have the
feature of allowing me to add columns or
increase the number of allowed characters in a
cell without erasing the data.


  

  
 
  4. Otherwise, I would like to export
  my data from Kexi and migrate over to
  MS Access. I have been using Kexi for
  many, many years-- but these basic
  limitations have made my work
  impossible.
  
  
  
  
I
  am sorry about that. The forum thread
  explains a bit the fact that these
  features mean larger endeavours so we
  need more contributors on

Re: Basic Questions

[Jaroslaw Staniek]

On Thu, 30 Jul 2020 at 23:26, Swarup  wrote:

>
>
> On 7/30/20 5:02 PM, Jaroslaw Staniek wrote:
>
>
>
> On Thu, 30 Jul 2020 at 21:44, Swarup  wrote:
>
>>
>>
>> On 7/30/20 3:32 PM, Jaroslaw Staniek wrote:
>>
>>
>>
>> On Thu, 30 Jul 2020 at 17:38, Swarup  wrote:
>>
>>> Hello
>>>
>>> 1. I am using Kexi Version 3.1.0  in Ubuntu 19.04.
>>>
>>> 2. I have very basic needs, such as the need to be able to add another
>>> column without erasing all my data, and the need to increase the number of
>>> characters allowed in a cell, without that change erasing all my data. As I
>>> understand, these things cannot be done in Version 3.1.0.
>>>
>>
>> Hello. Right. First step is to upgrade to 3.2.
>>
>> This topic can be studied here
>> https://forum.kde.org/viewtopic.php?f=221&t=132264
>>
>>
>>> 3. Is there a very easy, user friendly way to update to the latest
>>> version of Kexi?
>>>
>>
>> Always three ways as follows, whatever suits best:
>>
>> 1. Request an easy way from your distributor
>> 2. Change the distributor
>> 3. Install a Flatpak snapshot https://community.kde.org/Kexi/Snapshots
>>
>>
>> There is no point in me upgrading to the laterst version, if that version
>> doesn't have the feature of allowing me to add columns or increase the
>> number of allowed characters in a cell without erasing the data.
>>
>>
>>> 4. Otherwise, I would like to export my data from Kexi and migrate over
>>> to MS Access. I have been using Kexi for many, many years-- but these basic
>>> limitations have made my work impossible.
>>>
>>
>> I am sorry about that. The forum thread explains a bit the fact that
>> these features mean larger endeavours so we need more contributors on board.
>>
>>
>>>
>>> 5. I do not see any option in Kexi to export my data to say csv. This is
>>> an import option, but I do not see an export option. Where is the option to
>>> export my data?
>>>
>>
>> Users can export each table by right-clicking and exporting to a file.
>>
>>
>> This does not work. Any time I right click and select to export to a
>> file, kexi crashes and shuts down. I have seen this same problem reported
>> by several other users in the Ubuntu forums.
>>
>
> That may be the reason for upgrading...
>
>
> Are you telling me that if I upgrade, then the export feature will work?
>

My opinion is that it works in 3.2.0 and I worked on this issue for 3.2.0.
Natural thing: because the Ubuntu distributors are not part of the KEXI
project, they give no guarantee about their binaries, there is no 100%
guarantee how it will behave.


> Or are you guessing that it *may* work?
>
> Before I start putting big effort (which is what I know it is going to be,
> nothing with Kexi is straightforward), into upgrading, I want to know
> positively if the export feature works dependably or not.
>

Upgrading is not straightforward due to the distribution's guidelines. This
is why the Flatpak version of KEXI has been developed - to suit many
distributions in one go. If all effort is put into distributing, there
would be no time for new features or fix in KEXI. Alternative can be a paid
download.


>
>> Because these are SQLite tables, users can also run apps like
>> sqlitebrowser to export all tables in one go (File->Export->CSV).
>>
>> I am not a techy to start learning how to use apps like sqlitebrowser.
>>
>> I need to get my data out of kexi, and from what I am hearing from you
>> thus far it sounds, unfortunately, like my data is trapped in kexi and
>> unable to get out. Please provide me a simple solution that works to export
>> my data from Kexi. This is urgently needed.
>>
>
> There are ready to use tools, e.g.
> https://sqliteviewer.com/blog/export-sqlite-to-access/
> I hope it works for you.
>
>
> On the link you gave me, they themselves are writing "This method involves
> complicated procedure, which on going wrong can lead to loss of data from
> the Sqlite database".
>
> I am really regretting that I got my whole database stuck in Kexi. I've
> been using this since 2008 for the past 14 years, and now I wish to not
> remain stuck in this format any longer which has so many limitations. It
> should not be listed as the alternative to MS Access. The two cannot be
> compared.
>
> If you are able to provide me some real support and guidance for how to
> dependably get my data out of this program, I will be very grateful.
>

I am sorry to hear that the free support you received is insufficient. You
can consider finding a paid support, which would be potentially comparable
to MS Access - I guess email or phone support of MS Access isn't free.

Regarding the migration back, you need general guidance for "how to get
data from SQLite to MS Access".
There is no way to migrate forms and reports using a program, basically
because nobody paid for this function. Any programmer is free to write such
a tool and she/he will even receive integration support from the KEXI
folks. This is how new features appear in our environment - a matter of
need and choice.
Cheers.

-- 

Re: Basic Questions

[Swarup]

  
  


On 7/30/20 5:02 PM, Jaroslaw Staniek
  wrote:


  
  

  
  



  On Thu, 30 Jul 2020 at
21:44, Swarup 
wrote:
  
  
 
  
  On 7/30/20 3:32 PM, Jaroslaw Staniek wrote:
  
  

  


  
  
  
On Thu, 30 Jul
  2020 at 17:38, Swarup 
  wrote:


   Hello

1. I am using Kexi Version 3.1.0  in Ubuntu
19.04. 

2. I have very basic needs, such as the need to
be able to add another column without erasing
all my data, and the need to increase the number
of characters allowed in a cell, without that
change erasing all my data. As I understand,
these things cannot be done in Version 3.1.0.
  



Hello.
  Right. First step is to upgrade to 3.2. 


This
  topic can be studied here https://forum.kde.org/viewtopic.php?f=221&t=132264



   
3. Is there a very easy, user friendly way to
update to the latest version of Kexi?
  




  Always
three ways as follows, whatever suits best:
  

1.
  Request an easy way from your distributor 
2.
  Change the distributor
3.
  Install a Flatpak snapshot https://community.kde.org/Kexi/Snapshots
  

  
  
  There is no point in me upgrading to the laterst version,
  if that version doesn't have the feature of allowing me to
  add columns or increase the number of allowed characters
  in a cell without erasing the data.
  
  

  

   
4. Otherwise, I would like to export my data
from Kexi and migrate over to MS Access. I have
been using Kexi for many, many years-- but these
basic limitations have made my work impossible.




  I
am sorry about that. The forum thread explains a
bit the fact that these features mean larger
endeavours so we need more contributors on
board.

 

   
5. I do not see any option in Kexi to export my
data to say csv. This is an import option, but I
do not see an export option. Where is the option
to export my data?
  



Users
  can export each table by right-clicking and
  exporting to a file. 
  

  
  
  This does not work. Any time I right click and select to
  export to a file, kexi crashes and shuts down. I have seen
  this same problem reported by several other users in the
  Ubuntu forums.

  
  
  
  That
may be the reason for upgrading...

  


Are you telling me that if I upgrade, then the export feature will
work?

Or are you guessing that it may work?

Before I start putting big effort (which is what I know it is going
to be, nothing with Kexi is straightforward), into upgrading, I want
to know positively if the export feature works dependably or not.


  

  
 
  

  
Because
  these are SQLite tables

Re: Basic Questions

[Jaroslaw Staniek]

On Thu, 30 Jul 2020 at 21:44, Swarup  wrote:

>
>
> On 7/30/20 3:32 PM, Jaroslaw Staniek wrote:
>
>
>
> On Thu, 30 Jul 2020 at 17:38, Swarup  wrote:
>
>> Hello
>>
>> 1. I am using Kexi Version 3.1.0  in Ubuntu 19.04.
>>
>> 2. I have very basic needs, such as the need to be able to add another
>> column without erasing all my data, and the need to increase the number of
>> characters allowed in a cell, without that change erasing all my data. As I
>> understand, these things cannot be done in Version 3.1.0.
>>
>
> Hello. Right. First step is to upgrade to 3.2.
>
> This topic can be studied here
> https://forum.kde.org/viewtopic.php?f=221&t=132264
>
>
>> 3. Is there a very easy, user friendly way to update to the latest
>> version of Kexi?
>>
>
> Always three ways as follows, whatever suits best:
>
> 1. Request an easy way from your distributor
> 2. Change the distributor
> 3. Install a Flatpak snapshot https://community.kde.org/Kexi/Snapshots
>
>
> There is no point in me upgrading to the laterst version, if that version
> doesn't have the feature of allowing me to add columns or increase the
> number of allowed characters in a cell without erasing the data.
>
>
>> 4. Otherwise, I would like to export my data from Kexi and migrate over
>> to MS Access. I have been using Kexi for many, many years-- but these basic
>> limitations have made my work impossible.
>>
>
> I am sorry about that. The forum thread explains a bit the fact that these
> features mean larger endeavours so we need more contributors on board.
>
>
>>
>> 5. I do not see any option in Kexi to export my data to say csv. This is
>> an import option, but I do not see an export option. Where is the option to
>> export my data?
>>
>
> Users can export each table by right-clicking and exporting to a file.
>
>
> This does not work. Any time I right click and select to export to a file,
> kexi crashes and shuts down. I have seen this same problem reported by
> several other users in the Ubuntu forums.
>

That may be the reason for upgrading...

>
> Because these are SQLite tables, users can also run apps like
> sqlitebrowser to export all tables in one go (File->Export->CSV).
>
> I am not a techy to start learning how to use apps like sqlitebrowser.
>
> I need to get my data out of kexi, and from what I am hearing from you
> thus far it sounds, unfortunately, like my data is trapped in kexi and
> unable to get out. Please provide me a simple solution that works to export
> my data from Kexi. This is urgently needed.
>

There are ready to use tools, e.g.
https://sqliteviewer.com/blog/export-sqlite-to-access/
I hope it works for you.


> Thank you,
> Swarup
>


-- 
regards, Jaroslaw Staniek

KDE:
: A worldwide network of software engineers, artists, writers, translators
: and facilitators committed to Free Software development - kde.org
KEXI:
: A visual database apps builder - kexi-project.org calligra.org/kexi
  twitter.com/kexi_project facebook.com/kexi.project t.me/kexi_project
Qt Certified Specialist:
: linkedin.com/in/jstaniek 

Re: Basic Questions

[Swarup]

  
  


On 7/30/20 3:32 PM, Jaroslaw Staniek
  wrote:


  
  

  
  



  On Thu, 30 Jul 2020 at
17:38, Swarup 
wrote:
  
  
 Hello
  
  1. I am using Kexi Version 3.1.0  in Ubuntu 19.04. 
  
  2. I have very basic needs, such as the need to be able to
  add another column without erasing all my data, and the
  need to increase the number of characters allowed in a
  cell, without that change erasing all my data. As I
  understand, these things cannot be done in Version 3.1.0.

  
  
  
  Hello.
Right. First step is to upgrade to 3.2. 
  
  
  This
topic can be studied here https://forum.kde.org/viewtopic.php?f=221&t=132264
  
  
  
 
  3. Is there a very easy, user friendly way to update to
  the latest version of Kexi?

  
  
  
  
Always
  three ways as follows, whatever suits best:

  
  1.
Request an easy way from your distributor 
  2.
Change the distributor
  3.
Install a Flatpak snapshot https://community.kde.org/Kexi/Snapshots

  


There is no point in me upgrading to the laterst version, if that
version doesn't have the feature of allowing me to add columns or
increase the number of allowed characters in a cell without erasing
the data.


  

  
 
  4. Otherwise, I would like to export my data from Kexi and
  migrate over to MS Access. I have been using Kexi for
  many, many years-- but these basic limitations have made
  my work impossible.
  
  
  
  
I
  am sorry about that. The forum thread explains a bit the
  fact that these features mean larger endeavours so we need
  more contributors on board.
  
   
  
 
  5. I do not see any option in Kexi to export my data to
  say csv. This is an import option, but I do not see an
  export option. Where is the option to export my data?

  
  
  
  Users
can export each table by right-clicking and exporting to a
file. 

  


This does not work. Any time I right click and select to export to a
file, kexi crashes and shuts down. I have seen this same problem
reported by several other users in the Ubuntu forums.


  

  Because
these are SQLite tables, users can also run apps like
sqlitebrowser to export all tables in one go
(File->Export->CSV).


  

I am not a techy to start learning how to use apps like
sqlitebrowser.

I need to get my data out of kexi, and from what I am hearing from
you thus far it sounds, unfortunately, like my data is trapped in
kexi and unable to get out. Please provide me a simple solution that
works to export my data from Kexi. This is urgently needed.

Thank you,
Swarup
  

Re: Basic Questions

[Jaroslaw Staniek]

On Thu, 30 Jul 2020 at 17:38, Swarup  wrote:

> Helllo
>
> 1. I am using Kexi Version 3.1.0  in Ubuntu 19.04.
>
> 2. I have very basic needs, such as the need to be able to add another
> column without erasing all my data, and the need to increase the number of
> characters allowed in a cell, without that change erasing all my data. As I
> understand, these things cannot be done in Version 3.1.0.
>

Hello. Right. First step is to upgrade to 3.2.

This topic can be studied here
https://forum.kde.org/viewtopic.php?f=221&t=132264


> 3. Is there a very easy, user friendly way to update to the latest version
> of Kexi?
>

Always three ways as follows, whatever suits best:

1. Request an easy way from your distributor
2. Change the distributor
3. Install a Flatpak snapshot https://community.kde.org/Kexi/Snapshots

>
> 4. Otherwise, I would like to export my data from Kexi and migrate over to
> MS Access. I have been using Kexi for many, many years-- but these basic
> limitations have made my work impossible.
>

I am sorry about that. The forum thread explains a bit the fact that these
features mean larger endeavours so we need more contributors on board.


>
> 5. I do not see any option in Kexi to export my data to say csv. This is
> an import option, but I do not see an export option. Where is the option to
> export my data?
>

Users can export each table by right-clicking and exporting to a file.
Because these are SQLite tables, users can also run apps like sqlitebrowser
to export all tables in one go (File->Export->CSV).

-- 
regards, Jaroslaw Staniek

KDE:
: A worldwide network of software engineers, artists, writers, translators
: and facilitators committed to Free Software development - kde.org
KEXI:
: A visual database apps builder - kexi-project.org calligra.org/kexi
  twitter.com/kexi_project facebook.com/kexi.project t.me/kexi_project
Qt Certified Specialist:
: linkedin.com/in/jstaniek 

Re: Basic Questions

[Swarup]

  
  
In years past I have asked for solutions to the below items #2 and
#3, but there were none and so your team asked me to submit a
request for them, and I did that. 

If there are still no solutions, please kindly at least just tell
  me how to export my data from Kexi. I need to get on with my
work and need a platform which will allow for those functions.


On 7/30/20 11:38 AM, Swarup wrote:


  
  Helllo
  
  1. I am using Kexi Version 3.1.0  in Ubuntu 19.04. 
  
  2. I have very basic needs, such as the need to be able to add
  another column without erasing all my data, and the need to
  increase the number of characters allowed in a cell, without that
  change erasing all my data. As I understand, these things cannot
  be done in Version 3.1.0.
  
  3. Is there a very easy, user friendly way to update to the latest
  version of Kexi?
  
  4. Otherwise, I would like to export my data from Kexi and migrate
  over to MS Access. I have been using Kexi for many, many years--
  but these basic limitations have made my work impossible.
  
  5. I do not see any option in Kexi to export my data to say csv.
  This is an import option, but I do not see an export option. Where
  is the option to export my data?
  
  Thanks,
  Swarup 

  

Basic Questions

[Swarup]

  
  
Helllo

1. I am using Kexi Version 3.1.0  in Ubuntu 19.04. 

2. I have very basic needs, such as the need to be able to add
another column without erasing all my data, and the need to increase
the number of characters allowed in a cell, without that change
erasing all my data. As I understand, these things cannot be done in
Version 3.1.0.

3. Is there a very easy, user friendly way to update to the latest
version of Kexi?

4. Otherwise, I would like to export my data from Kexi and migrate
over to MS Access. I have been using Kexi for many, many years-- but
these basic limitations have made my work impossible.

5. I do not see any option in Kexi to export my data to say csv.
This is an import option, but I do not see an export option. Where
is the option to export my data?

Thanks,
Swarup
  

Re: [Kexi] Basic (?) questions on Queries

[Paul Thomas]

Hi Jaroslaw,

Thanks for your prompt and very detailed answers. All this seems promising 
and encourages spending some time in using kexi.

My primary goal is to "migrate" an MS access database with t0 tables, three 
of them with +/- 10 000 lines. A dozen of queries, some of them quite 
complex (cartesian, union + embedded queries). A good exercise to start 
with...

I've been looking at OOO base and kexi:
1. No doubt kexi offers the best way to transfer data from an MS access 
database. On top of that, OOO mdb connexion has some difficulties handling 
non latin1 character sets;
2. Also no doubt that kexi is far superior performance-wise.

Now, the points I raise dearlier seem to be already available with OOO. but 
you provided me good information and that could be enough to go. I still 
would like the "not yet" be transformed in "included" in the near future, 
but I understand that the qt4/kde4 migration is a big thing.

Thanks again,

Paul

_
Express yourself instantly with MSN Messenger! Download today it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi

Re: [Kexi] Basic (?) questions on Queries

[Jarosław Staniek]

Paul Thomas said the following, On 2007-03-01 20:20:

> 1. I tried to find out wether one can create queries based on more than one 
> occurence of a table. For example, if I only have one table "Names" 
> containing a liat of names (e.g. "Jones" "Doe"), the way to build a query 
> displaying all possible pairs of names would be something like:
> 
> SELECT names.name names_1.name AS name_1 FROM names, names AS names_1;
> 
> This works when entered in SQL mode, not in Design mode where it seems that 
> one table can be added only once. Am I wrong? Is it by design?

Hello Paul,
The visual design mode does not support this (cartesian product) definition. 
You obviously are able to switch directly to data mode and see the query works 
as expected. To avoid losing the design, save the query in SQL view.
Next time, you will be able to open the query properly (but still do not touch 
design view when working with this query).

This is a note for any statement that is not (yet) supported in the design view.

> 2. Can I build a query on a query?

Simiar problem as above - not yet.

> 3. Can a query create a table or appen rows to an existing table?

Not yet.

> 4. Not related to queries, but how would you recommend creating a report 
> based on a kexi table or base ?

option 1) export to XML using a Python "Export Data to XHTML File" script and 
then perform and XSLT transformation, what can give you pdf, html, etc.

See http://www.kexi-project.org/wiki/wikiview/index.php?ScriptingHandbook

option 2) Use "Simple printouts" function for rather simple cases
http://www.kexi-project.org/pics/1.0/simple_printouts.png

In general there is no groupping yet, so do not expect that complex 
computations to be performed directly in Kexi now.

option 3) preparing custom (e.g. command line) C++ app that uses OpenDocument 
variables to popualte database data for solution like mailmerge.
See http://www.kexi.pl/media/raporty/
This is most advanced, hard but powerful solution. In Kexi 2.x such things 
will be available without a need for programming.

> My apologies if those questions have already been answered in this list. I 
> tried to find them bu could not.

Thanks for asking, we should have them soon in the FAQ...

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice: http://www.kexi-project.org, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org
___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi

[Kexi] Basic (?) questions on Queries

[Paul Thomas]

Hello,

This is the first post I make on this list.

1. I tried to find out wether one can create queries based on more than one 
occurence of a table. For example, if I only have one table "Names" 
containing a liat of names (e.g. "Jones" "Doe"), the way to build a query 
displaying all possible pairs of names would be something like:

SELECT names.name names_1.name AS name_1 FROM names, names AS names_1;

This works when entered in SQL mode, not in Design mode where it seems that 
one table can be added only once. Am I wrong? Is it by design?

2. Can I build a query on a query?

3. Can a query create a table or appen rows to an existing table?

4. Not related to queries, but how would you recommend creating a report 
based on a kexi table or base ?

My apologies if those questions have already been answered in this list. I 
tried to find them bu could not.

Thank you in advance,

Paul

_
Don't just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/

___
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi