7.4.5.1 Base Table Copy Paste to Another Open Base File

[ocgirl]

An error occurred. Do you want to continue copying?

What are the possible reasons a working table would cause this error. I am not changing anything. The fields and field types are all the same. The table works in the original database. I have tried removing the primary key, and changing all fields to NO for required entry. It creates the tables with the column titles, but the data is not copied.

LO crashed earlier. I have been having problems copying for hours. At one point the copy, paste icons were greyed out for the tables. I could not use Cntl C or V either. I checked that I could use in other windows copying into Notepad. Eventually I could open a new spreadsheet and copy (not export) the table from Base into Calc.

I ran a defrag, and did disc clean. I checked that my clipboard was empty. History is not on, but I deleted it anyway. So far, I have uninstalled and reinstalled LO I think 3 times.

I removed the Primary Key from the original.

I right clicked Copy, Went to new file, Pasted, Chose Defination and Data.

Moved all fields into copy dialouge with correct Field Types.

I Clicked No do not create primary Key.

I clicked No.

Table is created without data.

[RobertG]

Reason might be bug 153003. Bug will be solved in next version of LO, 7.4.5.1 has been a hotfix release, so you have to wait for LO 7.4.6 - or use LO 7.5.0. But: I won’t use LO 7.5.0, because it changes borders of text form controls…

[ocgirl]

Thank you.

I read the Bugzilla report. I noticed that the fix is for a QUERY to be pasted into a Table page.

My issue is pasting a TABLE into a Table page.

Do you know if they are testing and fixing for both?

[RobertG]

It’s the same buggy behavior. And it is fixed in LO 7.5.0.3. But there are other bugs in this version with form controls, which aren’t confirmed like Bug 152974 for form controls. So I use LO 7.5.0.3 only for testing. Have installed many versions here parallel, so I could use another version for inserting data to a Base file.

[ocgirl]

How do you use multiple versions at the same time? Do you sandbox them or use a private window? I’ve haven’t done anything like this since forever and only on occasion way back then.

I am trying to download the old 7.3.7.2 ver. I had. (It was deleted when I ran disc clean the other night.) Is it normal for older versions to take so long to download?

What is the difference between .msi and .msi.asc?

[Wanderer]

@ocgirl

How do you use multiple versions at the same time?

At first: Avoid using at the same time - it can be confusing. If you need to do this I recommend using separate themes…
.
For Windows I can recommend the sperate install GUI:
https://wiki.documentfoundation.org/Installing_in_parallel/Windows

@ocgirl

difference between .msi and .msi.asc

The msi-file is the package you need to install. The .asc-file is much smaller and contains only the cryptographic signature of the msi-file, so one can verify the download and to have a copy wich was not modified by anybody.

[ocgirl]

I rolled back to LO 7.3.02. I was able to copy and paste the table. Now, it can’t parse the code. Fine, I can correct the SQL to run the query that has this table in it. I can’t set relationships because it says that the column types do not match.

They are both integers. They really are the same Field and data, in different tables. The first table has ID as the primary key. The 2nd table also has ID but it is combined with ID Common Name to make a new primary key for the 2nd table. Does this combination make it so that they can not be related? I can’t identify ID with ID?

I’m trying to figure out if there is a simple solve using sql to alter table or some other simple solution. What I am really trying to avoid is to copy, & paste, every single row in a sql statement. That is why I spent so much time trying to solve the copy paste issue that I now know is a bug,

If the combined primary key is not the issue, how far back in LO versions do I need to go?

[ocgirl]

+++++++The real issue is that the copied table now has all fields set to Text.++++++++
There are no options to change them to integer or numbers. It’s all set to Varchar.

I would still like to know if combing two integers make the first one unrelatable.

I remember reading about a bug but that was for 7.4, I beleive which is why I went back to 7.3

[RobertG]

@ocgirl

How do you use multiple versions at the same time?

Not with Windows. Linux here and about 25 Versions installed parallel for testing. I’m using LO 7.4.5.1 as default at this moment.
Relationships: Both fields Integer - one field must be primary key. Is there a value in foreign key which doesn’t exist in primary key?
Wizard for importing tables - field types: Third step of the wizard lets you choose the right field types.

[ocgirl]

I haven’t been able to find any threads on how to import a base table into a base file. Every thread seems to be about split database or sockets or something else. Since I can’t cut and paste how would I import a tables, queries and forms from one DB file to another DB file.

I have seen a video on how to export files to calc. If the DB is registered, you can see the export but when I tried to use the wizard it wanted me to start a whole new DB file, so I canceled. Is there a tutorial for this. I have been trying to get this done for 3 days now.

[RobertG]

@ocgirl

I haven’t been able to find any threads on how to import a base table into a base file.

Have a look here:
Base Guide 7.3 - Import data from other sources
It’s the same when importing data from on database file to another.

[mariosv]

Having several versions in Win it’s also possible, and easy with setup.exe it allows downloading the wanted version - and select where to install.