--00000000000004a9aa0587ef26ca Content-Type: text/plain; charset="UTF-8" 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 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 --00000000000004a9aa0587ef26ca Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Swarup
Order or records in= a database query or table can be defined using specific column of type tha= t can be sorted. This assumption is not mandatory though and can be ignored= .

The column to sort is usually of i= nteger type. Sort by this column, e.g. by clicking on the header and will b= e ordered.=C2=A0

Primary key is a go= od default sorting column which in addition is autoincremented so its sorti= ng 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 primar= y key column and some text column.
Before:
1 a
2 b
3 c

After renumbering:
1 inserted row
2 a
3 another inserted row=C2=A0=C2=A0
4 b
5 c

As you see it i= s renumbering as follows: 1->2, 2->3, 3->5.

<= /div>
What you ask for looks like a support for spreadsheet-like= behovior for tables/queries where records are strictly sorted and the orde= r 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=C2= =A0https://community.kde.org/Kexi/File_= a_bug_or_wish.


On Fri, 3 May 2019 at 00:00, = Swarup <dinbandhu@sprynet.com> wrote:
=20 =20 =20
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


--
--00000000000004a9aa0587ef26ca--