In LibreOffice Base, with a table control that can contain a list of records, when you select and move a record within the list, either a row or a record marker with a cursor + appears, creating a duplicate of the moved record or replacing the name of the record where the cursor was released.
Is there a way to prevent this from happening?
Function for copying a row will only run if the primary key is autovalue. Without this it will fails and returns an error.
Press ESC to get out when you see the “+”.
OK, for my database, it’s important to have auto-incrementing primary keys. So, this behavior is inevitable.
Is it possible for a macro associated with a table control event to prevent duplication? For example, a list row is accidentally moved into a blank space in the control, causing duplication, and the event captures it and prevents duplication or deletes the duplicated line?