질문하기

impocta's profile - activity

2019-04-09 22:37:12 +0200 받은 배지  유명한 질문 (source)
2018-12-13 09:18:45 +0200 코멘트달린 답변 How to disable automatic download of record in Base form?

@Ratslinger I see that I can prevent a large retrieval of data upon opening the form by leaving the form source table in

2018-12-13 09:01:13 +0200 으뜸 답변으로 표시됨 base form: how to make a check box with the default state 'not defined'.

I try to make forms with tristate check boxes that have a 'not defined' value as their default state. I want this because I want to force the users of the form to click every check box at least once. This way I know that they entered the information knowingly and don't just pass the check box values without thought. However as soon as I set NOT NULL in the table properties for the relevant collumns, the check boxes suddenly behave with 0 as their default value in the form, even though the check box control settings of the form are unchanged.

It looks like the default value from the table properties is forced over the check box control settings of the form. The check box only shows a default 'not defined' state if the collumn has a 'not defined' default state defined in the table properties and it proves to be inpossible to enter a 'not defined' default state in the table properties as long as a NOT NULL attribute is set to that collumn. I tried this (setting NOT NULL with default NULL) through the table editor gui and through sql (with the help of mysql workbench).

Am I facing a bug here? Or is there another way to get a working default 'not defined' check box on a collumn with NOT NULL attribute?

I am using LO Base 6.0.3.2 Build ID: 1:6.0.3-0ubuntu1 connected to an online MySQL database through driver: mysql-connector-java-5.1.45 on Xubuntu 18.04

2018-12-13 08:58:27 +0200 받은 배지  유명한 질문 (source)
2018-12-13 08:54:22 +0200 으뜸 답변으로 표시됨 Export base queries to .sql

I have accumulated a number of queries in libreoffice base. The large number of queries is causing the queries window to appear cluttered and thereby I'm don't have overview anymore. For this reason I decided I wanted to store my queries as .sql files and run them through mysql workbench. In that way I can order the queries (.sql files) in folders and keep a better overview.

One way to move the queries to .sql-files is by opening every base query in sql-view and copy-pasting the written commands. However, because that would be a labour intensive, repetitive job, I'm wondering if there is a way to do a batch export of base queries to .sql files.

I'm using Base 6.0.6 on Xubuntu 18.04

2018-12-09 06:19:23 +0200 받은 배지  주목할 만한 질문 (source)
2018-12-08 20:49:21 +0200 받은 배지  유명한 질문 (source)
2018-12-08 20:36:10 +0200 코멘트달린 답변 Base form 'input required' does not work

Great news!

2018-12-08 20:32:40 +0200 코멘트달린 답변 Export base queries to .sql

thanks, I tried the unzipping, it saved me some time.

2018-12-08 20:31:45 +0200 받은 배지  조력자 (source)
2018-12-08 20:17:49 +0200 받은 배지  논객
2018-12-08 20:17:49 +0200 코멘트달린 답변 Export base queries to .sql

Ratslinger is correct

2018-12-08 19:27:46 +0200 받은 배지  인기있는 질문 (source)
2018-12-08 14:17:21 +0200 질문하였습니다 Export base queries to .sql

Export base queries to .sql I have accumulated a number of queries in libreoffice base. The large number of queries is c

2018-11-27 18:42:12 +0200 받은 배지  학생 (source)
2018-11-27 18:40:34 +0200 받은 배지  유명한 질문 (source)
2018-11-05 20:47:53 +0200 받은 배지  유명한 질문 (source)
2018-10-09 16:58:06 +0200 받은 배지  주목할 만한 질문 (source)
2018-09-19 03:33:25 +0200 받은 배지  주목할 만한 질문 (source)
2018-09-03 18:14:58 +0200 코멘트달린 답변 base form: how to make a check box with the default state 'not defined'.

I use libreoffice 6.0.3.2 from ubuntu software sources and the mysql java connector 5.1.47 downloaded from the mysql web

2018-08-29 12:16:07 +0200 받은 배지  주목할 만한 질문 (source)
2018-08-29 01:35:21 +0200 코멘트달린 답변 base form: how to make a check box with the default state 'not defined'.

I want the field to be blank (NULL) when user to opens the form. However, for the record to be valid I need to have inpu

2018-08-29 01:26:47 +0200 으뜸 답변으로 표시됨 How to change check box size in base form

I searched the web, consulted the Libreoffice Base Handbook and I searched this forum, but I can't find how to change the size of a check box in a Base form.

Is it possible to change the size of a check box in a Base form?

2018-08-27 04:28:07 +0200 받은 배지  인기있는 질문 (source)
2018-08-27 00:25:48 +0200 받은 배지  주목할 만한 질문 (source)
2018-08-26 23:19:48 +0200 코멘트달린 답변 How to disable automatic download of record in Base form?

It looks like the macro is run too late to prevent the first 40 rows from being downloaded. When used with a table wit

2018-08-26 23:19:07 +0200 코멘트달린 답변 How to disable automatic download of record in Base form?

It looks like the macro is run too late to prevent the first 40 rows from being downloaded. When used with a table wit

2018-08-26 23:13:01 +0200 코멘트달린 답변 How to disable automatic download of record in Base form?

I did indeed attach it to the wrong 'open document'. I tried it again by opening a form containing MainForm and then too

2018-08-26 22:22:42 +0200 받은 배지  인기있는 질문 (source)
2018-08-26 22:18:23 +0200 질문하였습니다 base form: how to make a check box with the default state 'not defined'.

base form: how to make a check box with the default state 'not defined'. I try to make forms with tristate check boxes t

2018-08-26 20:30:55 +0200 질문하였습니다 How to change check box size in base form

How to change check box size in base form I searched the web, consulted the Libreoffice Base Handbook and I searched thi

2018-08-26 16:29:11 +0200 코멘트달린 답변 How to disable automatic download of record in Base form?

I expect that the 'open document' is not the right trigger to be used. I added a MsgBox to the macro in order to find ou

2018-08-26 15:00:23 +0200 코멘트달린 답변 How to disable automatic download of record in Base form?

I used the following: Sub RecordsRetrieved Dim oForm As Object oForm = ThisComponent.Drawpage.Forms.getByName("MainF

2018-08-26 14:58:49 +0200 코멘트달린 답변 How to disable automatic download of record in Base form?

You tempted me to try the world of macros. I found out what 'internal form' is and I found out how to create events and

2018-08-26 14:58:04 +0200 코멘트달린 답변 How to disable automatic download of record in Base form?

You tempted me to try the world of macros. I found out what 'internal form' is and I found out how to create events and

2018-08-26 14:04:34 +0200 코멘트달린 답변 Repeat a given alphanumeric sequence so many times eg abcd abcd abcd in excel

If you don't want an extra numerical collumn I would propose the following: B1: <sequence value="" 1=""> B2: <s

2018-08-24 10:12:05 +0200 받은 배지  인기있는 질문 (source)
2018-08-24 10:00:51 +0200 받은 배지  인기있는 질문 (source)
2018-08-24 00:23:33 +0200 질문하였습니다 How to disable automatic download of record in Base form?

How to disable automatic download of record in Base form? I have a table which contains several picture collumns. When I

2018-08-23 23:19:45 +0200 질문을 편집했습니다 Base form 'input required' does not work

Base form 'input required' does not work I added several new collumns to an existing table with data in it. At creation

2018-08-23 23:19:26 +0200 코멘트달린 답변 Base form 'input required' does not work

Thank you very much for this clear answer! It feels so great to know that it is a bug in the software and not just my ow

2018-08-23 23:10:56 +0200 으뜸 답변으로 표시됨 Base form 'input required' does not work

I added several new collumns to an existing table with data in it. At creation I marked these collumns: 'input required: no' because I don't know the correct content of these new collumns for the existing data, so these new collumns should remain empty for the already existing data.

However, for newly added data I want these new collumns to be mandatory for record creation. I imagined a solution to this exeption as follows: I have a form for new record creation only. Through the control dialog of the new collumns and then the data tab, I marked 'entry required' as 'yes'. I imagined that this configuration would prompt an error if the user tried to save a new record while the form controls of the new collumns were still empty. Sadly enough, it does not work. With the above described strategy I can create new records without filling out the new collumn form controls. I tried it with 'Empty string is NULL' both 'yes' and 'no'.

I am using LO Base 6.0.3.2 Build ID: 1:6.0.3-0ubuntu1 connected to an online MySQL database through driver: mysql-connector-java-5.1.45 on Xubuntu 18.04

My question is: how can I tackle this 'input required' exception through a form?

2018-08-23 23:10:56 +0200 받은 배지  학자 (source)
2018-08-23 21:19:55 +0200 질문을 편집했습니다 Base form 'input required' does not work

Base form 'input required' does not work I added several new collumns to an existing table with data in it. At creation

2018-08-23 21:19:55 +0200 받은 배지  편집자 (source)