[prev in list] [next in list] [prev in thread] [next in thread]
List: kexi
Subject: Re: Adding rows in Kexi 3.1.0
From: Jaroslaw Staniek <staniek () kde ! org>
Date: 2019-05-02 22:27:27
Message-ID: CAOj7QQ1tkAk-z_nd37udDDff2ULSS4wUo4hHSASh-BR3-ND2UQ () mail ! gmail ! com
[Download RAW message or body]
Hi Swarup
Order or records in a database query or table can be defined using specific
column of type that can be sorted. This assumption is not mandatory though
and can be ignored.
The column to sort is usually of integer type. Sort by this column, e.g. by
clicking on the header and will be ordered.
Primary key is a good default sorting column which in addition is
autoincremented so its sorting is out of the box.
In KEXI you can edit values even in this column so to reorder records you
have to edit the numbers accordingly.
E.g. consider table with the primary key column and some text column.
Before:
1 a
2 b
3 c
After renumbering:
1 inserted row
2 a
3 another inserted row
4 b
5 c
As you see it is renumbering as follows: 1->2, 2->3, 3->5.
What you ask for looks like a support for spreadsheet-like behovior for
tables/queries where records are strictly sorted and the order is
preserved. This is something I've been thinking about as extension, special
mode for the tabular view. Feel free to file a wish for it at
https://community.kde.org/Kexi/File_a_bug_or_wish.
On Fri, 3 May 2019 at 00:00, Swarup <dinbandhu@sprynet.com> wrote:
> I am using Kexi Version 3.1.0. Is there a way to insert a row above/below
> the current row in an existing table?
>
> Thanks,
> Swarup
>
--
regards, Jaroslaw Staniek
KDE:
: A world-wide 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 <http://www.linkedin.com/in/jstaniek>
[Attachment #3 (text/html)]
<div dir="ltr"><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">Hi Swarup</div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">Order or records in \
a database query or table can be defined using specific column of type that \
can be sorted. This assumption is not mandatory though and can be \
ignored.</div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small"><br></div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">The column to sort \
is usually of integer type. Sort by this column, e.g. by clicking on the \
header and will be ordered. </div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small"><br></div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">Primary key is a \
good default sorting column which in addition is autoincremented so its \
sorting is out of the box.</div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">In KEXI you can \
edit values even in this column so to reorder records you have to edit the \
numbers accordingly.</div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small"><br></div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">E.g. consider table \
with the primary key column and some text column.</div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">Before:</div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">1 a</div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">2 b</div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">3 c</div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small"><br></div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">After \
renumbering:</div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">1 inserted \
row</div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">2 a</div><div \
class="gmail_default" style="font-family:monospace,monospace">3 another \
inserted row <br></div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">4 b</div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">5 c<br></div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small"><br></div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">As you see it is \
renumbering as follows: 1->2, 2->3, 3->5.</div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small"><br></div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">What you ask for \
looks like a support for spreadsheet-like behovior for tables/queries where \
records are strictly sorted and the order is preserved. This is something \
I've been thinking about as extension, special mode for the tabular \
view. Feel free to file a wish for it at <a \
href="https://community.kde.org/Kexi/File_a_bug_or_wish" \
style="font-family:Arial,Helvetica,sans-serif">https://community.kde.org/Kexi/File_a_bug_or_wish</a>.</div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small"><br></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, 3 May 2019 at \
00:00, Swarup <<a \
href="mailto:dinbandhu@sprynet.com">dinbandhu@sprynet.com</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF">
I am using Kexi Version 3.1.0. Is there a way to insert a row
above/below the current row in an existing table?<br>
<br>
Thanks,<br>
Swarup
</div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" \
class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div \
dir="ltr"><div><div dir="ltr"><div>regards, Jaroslaw \
Staniek<br><br>KDE:<br>: A world-wide network of software engineers, \
artists, writers, translators<br>: and facilitators committed to Free \
Software development - <a href="http://kde.org" \
target="_blank">kde.org</a><br>KEXI:<br>: A visual database apps builder - \
<a href="http://kexi-project.org/" target="_blank">kexi-project.org</a> <a \
href="http://calligra.org/kexi" \
target="_blank">calligra.org/kexi</a></div><div> <a \
href="https://twitter.com/kexi_project" \
target="_blank">twitter.com/kexi_project</a> <a \
href="https://facebook.com/kexi.project" \
target="_blank">facebook.com/kexi.project</a> <a \
href="https://t.me/kexi_project" \
target="_blank">t.me/kexi_project</a><br>Qt Certified Specialist:<br>: <a \
href="http://www.linkedin.com/in/jstaniek" \
target="_blank">linkedin.com/in/jstaniek</a></div></div></div></div></div></div></div></div></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic