Unable to add rows in table - libreoffice base

jtm4890 · October 27, 2023, 9:41pm

can not add rows to fill my table, using ODBC for MariaDB with root user.

Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 12; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: es-PE (es_PE); UI: en-US
Calc: threaded

elmau · October 27, 2023, 11:44pm

Are you sure the table has at least one primary key?

jtm4890 · October 28, 2023, 1:08pm

Yes, it’s not possible to create table without define a primary key

RobertG · October 28, 2023, 2:24pm

@jtm4890 : You are using ODBC. Please also try it with the direct connection, which is part of LO.

elmau · October 28, 2023, 5:43pm

Yes, it is possible to have tables without a primary key.

jtm4890 · November 1, 2023, 1:38pm

FInally I found the solution, after create a table and add one primary key, is need restart the data base.

why this is need? no idea.

RobertG · November 1, 2023, 2:57pm

You really had started the database? Database here is MariaDB. Never seen such a behavior MariaDB doesn’t work directly with table with primary keys.
Or did you only start the LibreOffice Base file, which connects to this database? Then the driver isn’t installed correctly. Again: Try it with direct connection, is included in LibreOffice Base.