[Solved] Unable to edit data on imported table

Discuss the database features

[Solved] Unable to edit data on imported table

Postby 3BIL » Thu Jan 03, 2019 7:48 pm

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... :crazy: When I find how to... ( Now I saw it.... Need new glasses )


Any suggestions ???

Thanks,
Rafa.
3BIL.
Attachments
DDBB_y_CSV_ORIGEN.rar
(42.37 KiB) Downloaded 19 times
Last edited by 3BIL on Mon Jan 07, 2019 12:53 pm, edited 2 times in total.
LibreOffice 6.1.3.2 x64. Win10 Pro 64. Asus Laptop 8Gb 320Gb SSD
User avatar
3BIL
 
Posts: 8
Joined: Thu Jan 03, 2019 7:36 pm

Re: UNABLE TO EDIT DATA ON IMPORTED TABLE

Postby RoryOF » Thu Jan 03, 2019 7:58 pm

The Upload tab is below the Submit button on PostReply and FullEditor screens, not on QuickReply screen.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28563
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: UNABLE TO EDIT DATA ON IMPORTED TABLE

Postby 3BIL » Thu Jan 03, 2019 8:07 pm

Saw it.... Thaaks !!
LibreOffice 6.1.3.2 x64. Win10 Pro 64. Asus Laptop 8Gb 320Gb SSD
User avatar
3BIL
 
Posts: 8
Joined: Thu Jan 03, 2019 7:36 pm

Re: UNABLE TO EDIT DATA ON IMPORTED TABLE

Postby Villeroy » Thu Jan 03, 2019 8:24 pm

3BIL wrote: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   Expand viewCollapse view
ALTER TABLE "Tabla" ADD COLUMN "ID" INT IDENTITY

menu:View>Refresh Tables
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26553
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Unable to edit data on imported table

Postby 3BIL » Thu Jan 03, 2019 11:39 pm

Have you had a look to the attached file ??

I don't think so.
LibreOffice 6.1.3.2 x64. Win10 Pro 64. Asus Laptop 8Gb 320Gb SSD
User avatar
3BIL
 
Posts: 8
Joined: Thu Jan 03, 2019 7:36 pm

Re: Unable to edit data on imported table

Postby 3BIL » Thu Jan 03, 2019 11:41 pm

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...
LibreOffice 6.1.3.2 x64. Win10 Pro 64. Asus Laptop 8Gb 320Gb SSD
User avatar
3BIL
 
Posts: 8
Joined: Thu Jan 03, 2019 7:36 pm

Re: Unable to edit data on imported table

Postby Villeroy » Thu Jan 03, 2019 11:45 pm

Read some book on databases (not Access).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26553
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Unable to edit data on imported table

Postby 3BIL » Fri Jan 04, 2019 12:29 am

Thanks for a not helping at all answer...
LibreOffice 6.1.3.2 x64. Win10 Pro 64. Asus Laptop 8Gb 320Gb SSD
User avatar
3BIL
 
Posts: 8
Joined: Thu Jan 03, 2019 7:36 pm

Re: Unable to edit data on imported table

Postby 3BIL » Fri Jan 04, 2019 12:33 am

"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.
LibreOffice 6.1.3.2 x64. Win10 Pro 64. Asus Laptop 8Gb 320Gb SSD
User avatar
3BIL
 
Posts: 8
Joined: Thu Jan 03, 2019 7:36 pm

Re: Unable to edit data on imported table

Postby robleyd » Fri Jan 04, 2019 12:40 am

If you prefer to use your native language, see if there is a suitable language board at https://forum.openoffice.org/
Cheers
David
Apache OpenOffice 4.2.0 Build 9820 alpha version - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2569
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Unable to edit data on imported table

Postby UnklDonald418 » Fri Jan 04, 2019 6:53 pm

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.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1084
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Unable to edit data on imported table

Postby 3BIL » Sun Jan 06, 2019 11:00 pm

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.
LibreOffice 6.1.3.2 x64. Win10 Pro 64. Asus Laptop 8Gb 320Gb SSD
User avatar
3BIL
 
Posts: 8
Joined: Thu Jan 03, 2019 7:36 pm

Re: Unable to edit data on imported table

Postby UnklDonald418 » Mon Jan 07, 2019 6:33 am

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.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1084
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Unable to edit data on imported table

Postby 3BIL » Mon Jan 07, 2019 12:52 pm

Crystal clear !

Thanks for helping.
LibreOffice 6.1.3.2 x64. Win10 Pro 64. Asus Laptop 8Gb 320Gb SSD
User avatar
3BIL
 
Posts: 8
Joined: Thu Jan 03, 2019 7:36 pm


Return to Base

Who is online

Users browsing this forum: No registered users and 7 guests