Pergunte aqui

Perfil de David M - atividade

2019-05-25 20:08:02 +0200 Medalha recebida  Estudante (fonte)
2019-04-11 16:54:05 +0200 Medalha recebida  Pergunta famosa (fonte)
2019-03-15 02:42:14 +0200 Medalha recebida  Pergunta notável (fonte)
2019-03-12 20:18:30 +0200 Resposta comentada Form got broken with Libreoffice Base version 6.1.5.2 and later [MySQL(ODBC)]

Thanks to you both! I tried @Ratslinger 's answer and it worked. Both solutions were correct: editing the content.xml a

2019-03-12 20:06:53 +0200 Medalha recebida  Torcedor (fonte)
2019-03-12 20:06:45 +0200 Marcada como a melhor resposta Form got broken with Libreoffice Base version 6.1.5.2 and later [MySQL(ODBC)]

Hello:

I have a test database made in MySQL (using MySQL Workbench). This is a simple data base consisting on a form and a subform. I was thinking to migrate an HSQLDB to a MySQL Server, so I was learning about connections between Libreoffice and MySQL using ODBC drivers. I connected LO Base to Mysql as follows: Connect to existing database-->MySQL ; and then Connect with ODBC. Here I choose the DSN made with MySQL Connector ODBC 8.0.15.

Tables are related as shown below (the >> is suposed to show the relation).

tblMain  ----------------------------|   tblSubform 
ID INT(10) (PK, NN, AI, UN)---------->> ID_Mainform  INT(10) (FK, UN)
blah   (VARCHAR)---------------------|  IDSubform INT(10) (PK,NN,AI)
-------------------------------------|  blah VARCHAR

Then I used the LO Base wizard to make a Form with a Subform. This form worked in Libreoffice v6.0.7. I could add data, the autonumbering worked OK, data was stored and retrieved correctly. But with Libreoffice 6.1.5.2 and 6.2.1 the form is broken. When I open the form it gives me this error:

The data could not be loaded: invalid description index.

What could be happening?

I've attached the ODB file, and made a dump fie of the Mysql database. The last one could not be loaded in this forum, so I converted to text and pasted to a Writer Document.

Other info:

  • MySQL Server 5.7.25-log (MySQL Community Server (GPL))

  • Windows 10: Win64 (x84_64)

  • Connector ODBC 8.0.15

  • jre-9.0.1 (is active in Tools->Options->Advanced)

Test01_mysql_ODBC.odb

test01-BK-20190311.odt

2019-03-12 15:00:51 +0200 Medalha recebida  Pergunta popular (fonte)
2019-03-12 03:35:40 +0200 Pergunta editada Form got broken with Libreoffice Base version 6.1.5.2 and later [MySQL(ODBC)]

Form got broken with Libreoffice Base version 6.1.5.2 and later [MySQL(ODBC)] Hello: I have a test database made in My

2019-03-12 03:24:40 +0200 Perguntou Form got broken with Libreoffice Base version 6.1.5.2 and later [MySQL(ODBC)]

Form got broken with Libreoffice Base version 6.1.5.2 and later [MySQL(ODBC)] Hello: I have a test database made in My

2019-03-07 23:33:30 +0200 Medalha recebida  Entusiasta
2019-01-25 21:29:25 +0200 Respondeu uma pergunta Macro runs twice

I had a similar issue in LO Base. In Base 4.0 Handbook, some events are reported to run twice. I had this problem, wh

2016-09-09 06:56:13 +0200 Medalha recebida  Pergunta famosa (fonte)
2016-03-21 12:40:09 +0200 Medalha recebida  Pergunta notável (fonte)
2016-03-07 16:18:57 +0200 Medalha recebida  Acadêmico (fonte)
2016-03-07 15:34:47 +0200 Respondeu uma pergunta LO Base is not saving the field formatting when editing a table

Hi. That's my problem, actually. I set the format to 2 leading zeros, but when I close LO and I open it again, say the next day, the formatting is lost. Any idea why? Thanks

[EDIT] You were right, I was making the changes in the Edit Table window... But the permanent changes are made in the Table window, right click on the column, and Column Format. Thanks a lot!

2016-03-07 12:51:05 +0200 Medalha recebida  Pergunta popular (fonte)
2016-03-04 22:57:42 +0200 Medalha recebida  Editor (fonte)
2016-03-04 22:55:52 +0200 Perguntou LO Base is not saving the field formatting when editing a table

Hello,

I have a Pattern Field Mask using the Form Editor, in a little HSQLDB. I'm trying to avoid typos in an important field (the geographic position of the data taken). So I used the following mask:

NNLNN as the Edit Mask

"GG:DD" as the Literal Mask.

Let say I named the field as LAT. Then, in the Table editor, in the corresponding LAT field format example, I choose 2 leading zeros and 2 decimal places... so the data should be stored as: 09.45

The format field in Table Editor

Everything works OK during a session, but when I close LO, and I start the following day, the LAT field format example is lost to the default settings, so the data is stored as 9.45 (note there isn't a leading zero anymore). And this cause display problems in the Form... say instead of visualizing the data as 09.45, all I see is 94.5D

The last D came from the literal mask.

So, what I need is a way to set the LAT format field in a way it doesn't change between sessions.

Help is greatly appreciated.