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

On Fri, 3 May 2019 at 00:00, Swarup <dinban...@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

: A world-wide network of software engineers, artists, writers, translators
: and facilitators committed to Free Software development - kde.org
: 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>

Reply via email to