Hello all. I am new to LibreOffice and have much to learn. I am currently using Base and also learning about databases while using it. Maybe I am using Base incorrectly but I am trying to copy and paste a row from a table into the same table just to get basic functions down. I know it copies into the clipboard because I can paste the contents along with the column names into Calc, but I cannot paste the contents into a new row of another table or even the same table I am copying from. If someone can kindly point me in the right direction so I can move past this and continue my learning journey. Thank you so much to the community of support and to the developers.
Start with using Calc as intermediate:
Copy to a new table in Calc, as you already did. Then mark the whole table in Calc and Copy this.
Now select the destination table in the table-list of Base with right mouse-key and use paste. Now you should see an assistant handling the import.
.
Some problems are still lurking: A table needs (usually) a primary key to be editable and if you copy a row with this id back to the same table the database will (usually) interfere, because using this id twice is not allowed. If you delete the id in Calc you can copy to a table where the id/primary key has auto-increment. Without auto-increment you need to provide a unique value yourself.
Copying of a row in a table will only wok well with a AutoValue primary key.
Click on the left of a row with mouse to mark the row.
Hold left mouse button.
Move down (or up) a little bit. (+) will appear. Take finger from the mouse button. New row ill be inserted at the bottom of you table with new value for autoincemented primary key field (AutoValue).
You could do it also with more than one row, if you marked more than one row.
Thank you. This is exactly what I needed to know. After playing around with it for about an hour or so I feel much more comfortable transferring data into Base. Thanks again.
This is a great trick to know. Thanks for taking the time to reply to my post.