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 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.