[Solved] Unable to edit data on imported table

[3BIL]

Hi @ll,

I've been MS Access user, porgrammer, advisor and tech assistant... for too much years .


Now I had to move my activity to LibreOffice... And I'm really happy with the overall results but BASE.


I'm UNABLE to add or modify any register on an imported table from CALC ( I did by following EXACTLLY the directions given by all the guides : Selected all cells on CALC, swapp to BASE, and pasted as TABLE.

btw... Never mimd if adding or nor key.


Please, find attached a sample of the devil's table... When I find how to... ( Now I saw it.... Need new glasses )


Any suggestions ???

Thanks,
Rafa.
3BIL.

[RoryOF]

The Upload tab is below the Submit button on PostReply and FullEditor screens, not on QuickReply screen.

[3BIL]

Saw it.... Thaaks !!

[Villeroy]

Hi @ll,

I've been MS Access user, porgrammer, advisor and tech assistant... for too much years .

And you don't know anything about primary keys nor data types?

menu:Tools>SQL...

Code: Select all

ALTER TABLE "Tabla" ADD COLUMN "ID" INT IDENTITY

menu:View>Refresh Tables

[3BIL]

Have you had a look to the attached file ??

I don't think so.

[3BIL]

So...
Had the table reimported with autogenerated ID, now it lets me delete, add or modify registers.

So...

Whay is it that those actions CAN BE DONE on a NON ID'd registers when manually creating the table ??

It makes NO sense at all...

[Villeroy]

Read some book on databases (not Access).

[3BIL]

Thanks for a not helping at all answer...

[3BIL]

"Not answering comments" ( like yours ), make me lose all the faith I have always placed on non-commercial software.

NOTE;
BTW... English is my 3rd language, so... So sorry if not too exact saying something.

[robleyd]

If you prefer to use your native language, see if there is a suitable language board at https://forum.openoffice.org/

[UnklDonald418]

Whay is it that those actions CAN BE DONE on a NON ID'd registers when manually creating the table ??

All relational database engines require some sort of index to differentiate one record/row from another.
MSAccess apparently builds an internal index because primary keys are optional, but for most relational databases including the HSQLDB engine used by OO Base, a primary key is vital. While it is possible to create a table without a primary key, the table will be read only.
You can use most data types for a primary key, but in my experience you will often regret using something other than the recommended integer ID field.

[3BIL]

Ok.
Thanks for aswering.

I know PK is vital.

The weird case shows (as mentioned before) when manually creating a new table on OO Base, with NO PK, it's NOT read only...

This was the point making my head spinning.

Thanks for help.

Ciao,
Rafa.

[UnklDonald418]

That behavior isn't really so "weird" if you understand how programs like Base store data. I could try to explain, but it still wouldn't change the primary key requirement, so unless you really care, I'll skip the gory details.

An Embedded Base database with the 10 year old HSQLDB engine version 1.8 will only allow data to be added to a table without a primary key when it is created. After that the table is truly read-only.
When using a split database (JDBC) with a later version of HSQLDB (versions 2.3.2 and up) a table without a primary key IS_INSERTABLE_INTO. In other words, you can use INSERT INTO to add more rows to the table. But lacking a primary key it still has no way to locate rows to be updated.

[3BIL]

Crystal clear !

Thanks for helping.