Ask Your Question
1

Base: Create a table with data from a Calc's cell range by 'copy & paste'

asked 2020-08-22 12:17:37 +0100

lonk gravatar image

In the sample file, it could be done only 64 columns(A2:BL3).

Using 65 columns(A2:BM3), there was an error message.

The message is too big to be read. Is there any limitation on number of column ?

[ LibreOffice 6.2.8.2-2]

C:\fakepath\0016_CopyACellRangeFromCalcAndPasteOnEmbededFirebirdBaseToCreateANewTable.ods

image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2020-08-22 17:52:34 +0100

Ratslinger gravatar image

updated 2020-08-22 22:26:47 +0100

Hello,

Based on past questions this is regarding a Firebird database (should note in every question). Your error message does not show the beginning:

image description

You have exceeded the record size limit - See Database Limits

Also tested with HSQLDB and had no problem there.

Edit:

After a bit of thought, decided to have a look at the data being moved. It is nowhere near the limit specified.

After a few more trial runs, found that changing the field types (Type formatting page of the dialog) of BusinessCode to Integer (did set as primary key), EffectiveDate as Date and LastDate as Date the table was created without further problem.

Edit #2:

Just changed EffectiveDate as Date and LastDate as Date and set a primary key and all worked.

Seems to be some problems within this process. Should be reported -> Bugzilla

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-08-22 12:17:37 +0100

Seen: 50 times

Last updated: Aug 22 '20