質問する

PhLo's profile - activity

2019-10-03 01:27:25 +0200 バッジを受け取った  有名な質問 (source)
2019-09-17 18:42:47 +0200 バッジを受け取った  有名な質問 (source)
2019-08-25 19:52:09 +0200 バッジを受け取った  有名な質問 (source)
2019-03-29 09:20:01 +0200 バッジを受け取った  有名な質問 (source)
2019-02-06 13:34:52 +0200 バッジを受け取った  有名な質問 (source)
2019-02-04 22:55:49 +0200 バッジを受け取った  有名な質問 (source)
2019-01-31 03:06:24 +0200 バッジを受け取った  有名な質問 (source)
2019-01-18 22:39:29 +0200 バッジを受け取った  有名な質問 (source)
2019-01-16 02:31:42 +0200 バッジを受け取った  有名な質問 (source)
2018-12-16 16:44:26 +0200 バッジを受け取った  有名な質問 (source)
2018-12-13 09:47:09 +0200 バッジを受け取った  有名な質問 (source)
2018-12-13 09:44:45 +0200 コメント付き回答 dBase .dbf tables in base

Wow, nice catch. The filename case sensitivity is a pretty obscure problem to face!

2018-12-10 03:23:52 +0200 コメント付き質問 How do I insert an image into a Writer document

Agree about the scrollbars. It's a bad design choice not to have them. Easy to add in CSS { overflow:scroll; } (or "auto

2018-12-10 03:09:04 +0200 編集された回答 dBase .dbf tables in base

Calc can import dBase files as spreadsheets, and you can use spreadsheet columns from there as a mail merge source. You

2018-12-10 03:08:49 +0200 バッジを受け取った  市民パトロール (source)
2018-12-10 03:08:25 +0200 質問に回答する dBase .dbf tables in base

Calc can import dBase files as spreadsheets, and you can use spreadsheet columns from there as a mail merge source. You

2018-12-10 02:56:13 +0200 コメント付き質問 I can't get LibreOffice to recognise/find Java.

Try the less intrusive options offered by others first. However, if you are following the proper Java extension installa

2018-12-10 02:55:31 +0200 コメント付き質問 I can't get LibreOffice to recognise/find Java.

Try the less intrusive options offered by others first. However, if you are following the proper Java extension installa

2018-12-10 02:42:05 +0200 バッジを受け取った  卓越した質問 (source)
2018-12-07 21:21:14 +0200 バッジを受け取った  人気の質問 (source)
2018-12-07 21:21:14 +0200 バッジを受け取った  卓越した質問 (source)
2018-12-07 12:17:42 +0200 コメント付き回答 Base Macro - List Box as Quick Form Navigation

Imagine there are 10 records available in this Contacts form: 1 - John, 2 - Frank, 3 - Melissa, 4 - Kyle, 5 - Thomas, 6

2018-12-07 12:15:20 +0200 コメント付き回答 Base Macro - List Box as Quick Form Navigation

Imagine there are 10 records available in this Contacts form: 1 - John, 2 - Frank, 3 - Melissa, 4 - Kyle, 5 - Thomas, 6

2018-12-07 12:13:51 +0200 コメント付き回答 Base Macro - List Box as Quick Form Navigation

Imagine there are 10 records available in this Contacts form: 1 - John, 2 - Frank, 3 - Melissa, 4 - Kyle, 5 - Thomas, 6

2018-12-07 12:12:51 +0200 コメント付き回答 Base Macro - List Box as Quick Form Navigation

Imagine there are 10 records available in this Contacts form: 1 - John, 2 - Frank, 3 - Melissa, 4 - Kyle, 5 - Thomas, 6

2018-12-07 12:12:06 +0200 コメント付き回答 Base Macro - List Box as Quick Form Navigation

Imagine there are 10 records available in this Contacts form: 1 - John, 2 - Frank, 3 - Melissa, 4 - Kyle, 5 - Thomas, 6

2018-12-07 12:10:49 +0200 コメント付き回答 Base Macro - List Box as Quick Form Navigation

Imagine that there are 10 records that would be available in this Contacts form: 1 - John, 2 - Frank, 3 - Melissa, 4 - K

2018-12-07 12:10:38 +0200 コメント付き回答 Base Macro - List Box as Quick Form Navigation

Imagine that there are 10 records that would be available in this Contacts form: 1 - John, 2 - Frank, 3 - Melissa, 4 - K

2018-12-07 12:08:59 +0200 コメント付き回答 Base Macro - List Box as Quick Form Navigation

Imagine that there are 10 records that would be available in this Contacts form: 1 - John, 2 - Frank, 3 - Melissa, 4 - K

2018-12-07 12:03:12 +0200 コメント付き回答 Base Macro - List Box as Quick Form Navigation

Sorry, not possible. Nothing would work for anyone else in my file because it connects to a MySQL database on the backen

2018-12-07 12:00:56 +0200 コメント付き回答 Base Macro - List Box as Quick Form Navigation

Sorry, not possible. Nothing would work because it connects to a MySQL database on the backend, plus I don't want to pro

2018-12-07 11:56:25 +0200 編集された質問 Base Macro - List Box as Quick Form Navigation

Base Macro - List Box as Quick Form Navigation This should be easy, but I can't figure it out. I want to use a drop-dow

2018-12-07 11:28:46 +0200 編集された質問 Base Macro - List Box as Quick Form Navigation

Base Macro - List Box as Quick Form Navigation This should be easy, but I can't figure it out. I want to use a drop-dow

2018-12-07 11:28:01 +0200 編集された質問 Base Macro - List Box as Quick Form Navigation

Base Macro - List Box as Quick Form Navigation This should be easy, but I can't figure it out. I want to use a drop-dow

2018-12-07 11:24:59 +0200 質問をする Base Macro - List Box as Quick Form Navigation

Base Macro - List Box as Quick Form Navigation This should be easy, but I can't figure it out. I want to use a drop-dow

2018-12-04 05:29:54 +0200 コメント付き回答 Regular Expressions not working as expecting: remove a line

Yay, Finland. Writer's regular expression support is abysmal at best, at least in regards to new line characters. I'm en

2018-12-04 03:35:20 +0200 コメント付き質問 How to stop separation of letters in words, very frequent

It seems like a symptom of a cut & paste operation from an unusual source. It's possible the spaces or other weird b

2018-12-03 00:01:18 +0200 バッジを受け取った  ネクロマンサー (source)
2018-11-28 23:03:50 +0200 コメント付き回答 Base Prevent Form Execute on Page Launch

Nope, that second Native MySQL driver doesn't work either. When trying to install it throws the error message "MySQL SDB

2018-11-28 20:09:55 +0200 コメント付き質問 LibreOffice Calc has 1,024 columns?

I understand why this limit exists... large chunks of Calc's codebase would need to be rewritten, but hopefully someone

2018-11-28 19:55:25 +0200 コメント付き質問 LibreOffice Calc has 1,024 columns?

I understand why this limit exists... large chunks of Calc's codebase would need to be rewritten, but hopefully someone

2018-11-28 19:48:20 +0200 コメント付き質問 LibreOffice Calc has 1,024 columns?

I understand why this limit exists... large chunks of Calc's codebase would need to be rewritten, but hopefully someone

2018-11-28 19:30:16 +0200 コメント付き質問 MS OneNote equalivent in LibreOffice?

Not a bad question. Something like OneNote or Evernote wouldn't be a bad addition. I don't personally use such apps, but

2018-11-28 19:28:22 +0200 コメント付き質問 MS OneNote equalivent in LibreOffice?

Not a bad question. Something like OneNote or Evernote wouldn't be a bad addition. I don't personally use such apps, but

2018-11-28 19:27:15 +0200 コメント付き質問 MS OneNote equalivent in LibreOffice?

Not a bad question. Something like OneNote or Evernote wouldn't be a bad addition. I don't personally use such apps, but

2018-11-28 19:26:26 +0200 コメント付き質問 MS OneNote equalivent in LibreOffice?

Not a bad question. Something like OneNote or Evernote wouldn't be a bad addition. I don't personally use such apps, but

2018-11-28 19:22:14 +0200 コメント付き回答 Base Prevent Form Execute on Page Launch

Fair enough. You're right. Doesn't alleviate the need to write excessive code, but I guess I didn't ask for miracles. Si

2018-11-28 19:20:36 +0200 ベストアンサーマーク Base Prevent Form Execute on Page Launch

I'm writing macros that fill in the various parameters of a form before executing it and reloading it. For example:

oForm = thisComponent.drawpage.forms.getByName("frmNote")
oForm.escapeProcessing = True
oForm.commandType = 2
oForm.command = "SELECT * FROM `note`"
oForm.filter = " `tablename` = 'account' AND `status` = 1 "
oForm.order = " `importance` DESC "
oForm.setPropertyValue("MaxRows", 10)
oForm.setPropertyValue("FetchSize", 10)
oForm.execute()
oForm.reload()

Above is a sample of code I use to load a form immediately after that "page" is opened. I say "page" because Base's terminology is confusing in that [page] "forms" (document/page/windowed "thing") can have [control/data] "forms" inside them. I'm loading a [page] form via ThisDataBaseDocument.CurrentController.Connect() and .loadComponent() functions, and then I wish to load the contained [control/data] form programmatically.

My problem is this: Base tries to load the [control/data] form already with whatever is typed in the Form PropertiesData dialog as soon as the form document is rendered. Therefore, when I also do my execute, it is populating the form twice.

My question is, can I disable the [control/data] form from loading what is in its Form PropertiesData dialog so that I can limit the records myself via a SQL command? I'm trying to circumvent Base's default behavior on forms tied to large table sources so that the entire table isn't loaded into memory. It takes far too long and causes Base to become unusable.

In most cases I only want to fetch 1 single row of data or possibly something like the "top ten," and so I am writing macros to feed the primary key dynamically or else telling it to only give me 10 results ordered by a particular column. The most common situation is where I want to only show one "Edit" record in a form, and I therefore modify the filter to be something like WHERE id = 12345. Base "does its slow thing" before I'm able to feed in these parameters and execute. Then my execute() loads the [control/data] form yet again, so I can't make lean / limit its queries.

It would be great to be able to disable the default [control/data] form execution immediately after the following lines of code which open a new [page] form so that I can specify the parameters before execution.

Function openFormDocument(sDocumentName As String)
    Dim vComponent
    vComponent = com.sun.star.sdb.application.DatabaseObject.FORM
    If ThisDatabaseDocument.FormDocuments.hasbyname(sDocumentName) Then 'Check the form exists
        ThisDataBaseDocument.CurrentController.Connect() 'If the form exists connect to the database
        ThisDatabaseDocument.CurrentController.loadComponent(vComponent, sDocumentName, False) 'Open the form
        openFormDocument = ThisDatabaseDocument.FormDocuments.getbyname(sDocumentName).getComponent() 'return new document object
        **INSERT CODE TO DISABLE DEFAULT FORM EXECUTION**
    Else
        MsgBox "Error! Wrong form name used. " & sDocumentName
    End if
End Function

Is there a command to disable automatic form execution?

As a side note, I don't understand why groupBy, havingClause, maxRows, fetchSize and other query parameters aren't exposed in the Form Properties dialog. Only ... (more)