<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body style="background-color: rgb(255, 255, 255); color: rgb(0, 0,
0);" bgcolor="#FFFFFF" text="#000000">
<br>
<br>
<div class="moz-cite-prefix">On 04/15/2016 11:10 AM, Jaroslaw
Staniek wrote:<br>
</div>
<blockquote
cite="mid:CAOj7QQ3EZwFnv50kjh3Qc+mz5i6sK-6_-toPuFbE0jeg_p7ZOA@mail.gmail.com"
type="cite">
<pre wrap="">On 15 April 2016 at 14:47, Swarup <a class="moz-txt-link-rfc2396E" href="mailto:dinbandhu@sprynet.com"><dinbandhu@sprynet.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">2. Will the version of Kexi which is included have the following features:
-Ability to add rows to the middle of a table which is already in
existence
</pre>
</blockquote>
</blockquote>
<pre wrap="">
I see how it may be usable. It's not supported now.
Database table is not a spreadsheet's sheet, so the order is defined
by current sorting, for given column, based on contents. Even if we
have this feature, placement of a new row would be kept until another
sorting or re-opening the table view. This my be the reason why I know
no software that supports the feature.</pre>
</blockquote>
<br>
MS Access has this feature, and has had it for many, many years. All
the features I asked about are long-held features of MS Access. I
migrated from Windows to Linux ten years ago and have been with
Linux systems ever since, but these features of MS Access are things
I sorely miss. My brother also works on Ubuntu on his Mac, and has
installed Parallels (virtual software) so he could install Windows,
just so that he could use MS Access. <br>
<blockquote
cite="mid:CAOj7QQ3EZwFnv50kjh3Qc+mz5i6sK-6_-toPuFbE0jeg_p7ZOA@mail.gmail.com"
type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">-Ability to add columns to the middle of a table which is already in
existence
</pre>
</blockquote>
</blockquote>
<pre wrap="">
Yes, it has been available for a long time. But table is recreated
then from scratch without prior data.
We're collecting funds for this big development:
<a class="moz-txt-link-freetext" href="https://www.bountysource.com/issues/26881135-add-support-for-alter-table-s-design-without-losing-data">https://www.bountysource.com/issues/26881135-add-support-for-alter-table-s-design-without-losing-data</a></pre>
</blockquote>
It it destroys all the data, the feature is of no use. Again, this
has been a standard feature of MSA for many, many years. One can do
any sort of manipulation of an MSA table: rearrange rows, rearrange
columns, rename columns, add new rows and columns in the middle of
pre-existing tables, highlight and copy-paste sections of the table
and past it in other sections of the table. The MSA table is so
fluid and flexible. And it is this very maneuverability that Liinux
users still write about and lament the loss of when they moved to
Linux. <br>
<br>
<blockquote
cite="mid:CAOj7QQ3EZwFnv50kjh3Qc+mz5i6sK-6_-toPuFbE0jeg_p7ZOA@mail.gmail.com"
type="cite">
<pre wrap="">
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">-Ability to change the name of a column in an existing table. (Currently
this requires going into the data view, with the warning that making any
changes will wipe out all the data in the table)
</pre>
</blockquote>
</blockquote>
<pre wrap="">
It's unsupported like the above.
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">-Ability to move existing rows/columns in a table which is already in
existence
</pre>
</blockquote>
</blockquote>
<pre wrap="">
This wish is reported, feel free to vote for it.
<a class="moz-txt-link-freetext" href="https://bugs.kde.org/show_bug.cgi?id=361362">https://bugs.kde.org/show_bug.cgi?id=361362</a>
</pre>
</blockquote>
<br>
My intent here was not at all to rub Kexi's nose in the dirt; I know
you are working hard and I appreciate the progress you've made. I
only raised the subject as you said you'd never seen any DB software
that has the row-adding feature. In my mind, if I have to describe
the ideal DB software today though, it does still remain MSA. If you
are able to replicate the amazing features in MSA, you will have
truly created an amazing tool for Linux users.<br>
<br>
Swarup<br>
<br>
</body>
</html>