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