Ask Your Question
0

Problem with Firebird in LibreOffice Base

asked 2020-12-15 13:26:43 +0100

Giorgos_pap gravatar image

updated 2021-01-02 22:08:10 +0100

Hello again and happy new - covid free - year ! I’ve read carefully your remarks. I’m a newcomer in LO. I had worked with MS Access before, almost 20 years and a little bit with Open Office. Now I must have a database and it’s like to start all over again. And I think that you can make the best start with the tutorial. Firstly, I installed LO version 7.0.3.1. The only step I didn’t follow is that I choose embedded Firebird because I read that HSQLDB is out of date and it will be replaced in the future. I followed step by step (apart from the aforementioned choice) the ’Libre Office, Getting started guide, Chapter 8, Getting started with Base’, I created a new database (called Automobile), I followed Step 1: select fields (I used the CD collection sample table in the personal category and Employees in the business category), then Step 2: Set field types and formats, then Step 3: Set primary key and when I followed Step 4: Create table (page 11) and clicked Finish there was the following ERROR displayed:

firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104 *Name longer than database column size caused by 'isc_dsql_prepare'

I thing that I gave all the details of the procedure. This is the point where I need some help.

edit retag flag offensive close merge delete

Comments

Please don't use all uppercase in your title - this is considered yelling.

Opaque gravatar imageOpaque ( 2020-12-15 13:28:49 +0100 )edit

@Giorgos_pap,

Cannot duplicate on Ubuntu 20.04 with LO v7.0.3.1

Please provide more information - OS used; specific LO version; Exactly what you are doing including names and field types/sizes used. Can't refer to anything unless the problem is identified. My best guess is you may be using a an older LO version than I tested with.

Ratslinger gravatar imageRatslinger ( 2020-12-15 20:10:28 +0100 )edit

Thank you very much. I'll try with the older LO version and I'll give details as soon as I have time. Thank you very much again !

Giorgos_pap gravatar imageGiorgos_pap ( 2020-12-15 21:07:29 +0100 )edit

@Giorgos_pap,

I believe you do not understand. My newer version will not allow names longer than 30 characters. I believe you are using an older version than I am and that is how you are getting an error. But I can't say for certain. This is why I asked for the information in the above comment. Please provide that information. You using an older version will almost certainly not be of any help. You will most likely get the same errors.

Edit:

Just an educated guess. Try creating the table where the table and field names are less than 30 characters.

Ratslinger gravatar imageRatslinger ( 2020-12-15 21:22:23 +0100 )edit

Dear @Ratslinger,

Sorry for cutting in,

I can create filed name with 31 characters.

"Address07IndustrialEstateEnglis" VARCHAR(50),

Will there be any problem in the future ?

Fedora 33 Workstation + LibreOffice 7.0.4/Base:Embedded Firebird
lonk gravatar imagelonk ( 2020-12-17 10:20:04 +0100 )edit
1

@lonk,

31 seems to be current limit.

Ratslinger gravatar imageRatslinger ( 2020-12-17 18:29:56 +0100 )edit

@Giorgos_pap,

Still cannot reproduce your error based upon your latest information. Can generate a different error if large field sizes are used.

Do need this information previously asked for:

...including names and field types/sizes used.

This is field and table names and field types and sizes.

Ratslinger gravatar imageRatslinger ( 2020-12-17 18:35:12 +0100 )edit

Just finished following all the steps as in the documentation (but used Firebird embedded database as in question) and had no problems. Used default table name and all settings as noted.

Ratslinger gravatar imageRatslinger ( 2021-01-03 01:55:39 +0100 )edit

@Giorgos_pap,

Can only guess there is something different with your creation than the document or my entry. Problem is that it cannot be seen as to what you have.

Ratslinger gravatar imageRatslinger ( 2021-01-04 22:48:13 +0100 )edit

I see. Thanks !

Giorgos_pap gravatar imageGiorgos_pap ( 2021-01-05 14:23:23 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2021-01-04 22:51:15 +0100

Ratslinger gravatar image

@Giorgos_pap,

Here is a copy of the Base file I created from the instructions - Automobile.odb

edit flag offensive delete link more

Comments

If I didn't find the solution I'll probably try openoffice again

Giorgos_pap gravatar imageGiorgos_pap ( 2021-01-05 18:56:43 +0100 )edit

I tried it again twice. I don't know if the problem is the Greek language but I don't think so. There must be something else.

Giorgos_pap gravatar imageGiorgos_pap ( 2021-01-05 18:58:04 +0100 )edit

I tried to create a differnet small database with four arbitrary fields and it worked. This is weird !!

Giorgos_pap gravatar imageGiorgos_pap ( 2021-01-05 19:09:18 +0100 )edit

Well it seems that the language is the problem. I changed the field names from Greek to English and guess what ? It WORKED !!!

Giorgos_pap gravatar imageGiorgos_pap ( 2021-01-05 22:28:03 +0100 )edit
0

answered 2021-01-06 13:12:27 +0100

Giorgos_pap gravatar image

updated 2021-01-06 13:30:36 +0100

After a lot of attemts both with wizard and in design mode, I realized that that Greek language of field names is a problem when I tried to reproduce the tutorial. When I typed the same names in English language there wasn't any problem. I dont't know what will happen when I will add data in Greek language. When I'll reach that stage, I'll see. But typing field names in Greek (in the tutorial) causes a problem. So, the answer is to type field names in English (I don't know about other languages and I don't know why there's a problem with Greek language). Also, I don't know what will happen if i try to create a new database with the field names in Greek. When I'll have free time I'll check it out.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-12-15 13:26:43 +0100

Seen: 144 times

Last updated: Jan 06