I am using a table in which the first two fields constitute the primary key, and of these the second may be blank, thus:
Boston Centre Some other info Boston Suburbs Some other info Cambridge Info on whole of Cambridge
The table is stored in SQLite, which has no objection to this structure, provided that the empty key field is blank ("") and not NULL. However, my front-end in LibreOffice Base (version 220.127.116.11) seems unable to cope with this, whether I open the table directly or display it in a table-grid on a form. It is confused about record numbers (claiming e.g. that there are 129 records, when there are 141) and, while I can get correctly from the beginning to the end by scrolling through the table, if I click on the ‘Last record’ button I get an error message ‘Failed to refetch row’.
Has anyone else come across this and, if so, is there a solution?