Stel uw vraag

Lovro's profiel - activiteit

2019-02-25 14:44:58 +0200 badge ontvangen  Beroemde vraag (bron)
2019-01-02 17:26:07 +0200 beantwoorde een vraag allow additions with subform

I found the answer. I also had "Allow changes" and "Allow deletions" flags on form set to "No", which caused such behavi

2019-01-02 17:24:06 +0200 bewerkte een vraag allow additions with subform

allow additions with subform I created a form which has "Allow new data" set to true, to only allow new records to be ad

2019-01-02 17:19:14 +0200 bewerkte een vraag allow additions with subform

allow additions with subform I created a form which has "Allow additions" set to true, to only allow new records to be a

2019-01-02 17:18:05 +0200 stelde een vraag allow additions with subform

allow additions with subform I created a form which has "Allow additions" set to true, to only allow new records to be a

2018-10-29 14:19:50 +0200 badge ontvangen  Beroemde vraag (bron)
2018-02-07 16:05:04 +0200 reageerde op een antwoord Base: is there a way to disable the close button on a form?

Unloading event do not work for me either. I think it is a bug

2018-02-07 13:31:52 +0200 reageerde op een antwoord using basic to change form current record state to "not saved"

Hello, this option is only partial solution, as contents of the listbox should be updated to dedicated table (different

2018-02-07 13:21:14 +0200 badge ontvangen  Opvallende Vraag (bron)
2018-01-31 15:53:47 +0200 reageerde op een antwoord using basic to change form current record state to "not saved"

i got it to work with this workaround was meant on this workaround (in text): "One workaround I can think of is to creat

2018-01-31 15:53:47 +0200 badge ontvangen  Commentator
2018-01-31 09:58:43 +0200 reageerde op een antwoord using basic to change form current record state to "not saved"

Hello, sorry again for not clearing things up. Data for the listbox come from another table, different from the table fo

2018-01-31 08:49:54 +0200 badge ontvangen  enthousiast
2018-01-30 17:31:21 +0200 badge ontvangen  Populaire Vraag (bron)
2018-01-30 17:06:00 +0200 bewerkte een vraag using basic to change form current record state to "not saved"

using basic to change form current record state to "not saved" In Libreoffice base, I have one listbox control on a form

2018-01-30 16:24:55 +0200 bewerkte een vraag using basic to change form current record state to "not saved"

using basic to change for current record state to "not saved" In Libreoffice base, I have one listbox control on a form

2018-01-30 16:24:46 +0200 bewerkte een vraag using basic to change form current record state to "not saved"

can't get isModified Form property to work as I expect In Libreoffice base, I have one listbox control on a form which I

2018-01-30 16:20:55 +0200 reageerde op een vraag using basic to change form current record state to "not saved"

Hello, I tried to make my question more concise, I hope I succeded.

2018-01-30 16:20:06 +0200 bewerkte een vraag using basic to change form current record state to "not saved"

can't get isModified Form property to work as I expect In Libreoffice base, I have one listbox control on a form which I

2018-01-30 16:13:50 +0200 bewerkte een vraag using basic to change form current record state to "not saved"

can't get isModified Form property to work as I expect In Libreoffice base, I have one listbox control on a form which I

2018-01-27 20:10:32 +0200 stelde een vraag using basic to change form current record state to "not saved"

can't get isModified Form property to work as I expect In Libreoffice base, I have one listbox control on a form which I

2017-04-09 23:44:42 +0200 badge ontvangen  Beroemde vraag (bron)
2017-03-12 04:34:02 +0200 badge ontvangen  Opvallende Vraag (bron)
2017-02-10 09:15:41 +0200 reageerde op een vraag custom database split

If anyone is interested in my "splitting" database solution, as well as running HSQLDB server instance as a service (without ugly console window), and how to connect to it from Base, ask for instructions and I will provide them.

2017-02-10 09:13:48 +0200 reageerde op een antwoord custom database split

Dear Ratslinger, once again you offered great help. I encountered the very same problem you are talking about (i.e. embedded base not working any more). I started to repair old database myself, but I did not manage to do it all the way. Thanks for anticipating my problem and offering solution to it.

2017-02-10 07:36:19 +0200 badge ontvangen  Populaire Vraag (bron)
2017-02-09 14:46:18 +0200 stelde een vraag custom database split

Hello, I want to have database environment with several users using base front-end which I developed. I want to use HSQLDB 2.3.4 database on my computer running in server mode, to which users connect. For the sake of simplicity, I developed base document so far as embedded solution and now I want to split it into front-end and back-end parts. After reading about splitting database not so thoroughly :) due to size and complexity of the text, I decided to take simpler approach (e.g. I did it my way :)) :

Since there is no way to connect to a different database from base UI, nor possibility to import forms and reports from another base file, I did it with a "hack".

  1. I took odb file A (embedded HSQLDB solution with forms, reports and views), opened it with a zip utility and extracted database files (according to the HSQLDB manual) into separate folder. I started HSQLDB server, which I downloaded from official page with my database.
  2. I prepared odb file B as an empty Base document, but I prepared connection to my HSQLDB server
  3. I opened odb file B .odb file with zip utility and extracted content.xml. I copied everything between <db:data-source> opening and closing XML tag. I closed database B
  4. I opened odb fileA .odb file and replaced everything between <db:data-source> opening and closing XML tags with copied text
  5. For the sake of neatness, I deleted database folder in odb file A

I found that this "hack" solution at my surprise works! I tested it and everything seems fine.

Now, the question: can I expect data corruption/odd behaviour/other problems with this solution? Everything seems fine so far. Thanks!

2017-01-29 03:10:12 +0200 badge ontvangen  Opvallende Vraag (bron)
2017-01-26 16:58:21 +0200 koos een beste antwoord Mail merge does not work

Hello, I am having problem with mailmerge macro functionality. Following macro (below) is in another (Base) document, it finishes with no errors, but document is not showing if outputtype is set to SHELL (4). If I set it to FILE (2) then I get file, but the fields are not populated from database. I would like to have document show on screen and fields populated with field values from database record.

    Dim mm as Object
mm = CreateUnoService("com.sun.star.text.MailMerge") 
'set dbMasterfields = oDoc.getTextFieldMasters()
with mm
    .OutputType = com.sun.star.text.MailMergeType.SHELL
    .OutputUrl = "file:///C:/temp/"
    .DocumentURL = ConvertToURL("C:\Users\Lovro Hrust\Documents\Državna mreža\OB-5.3.2.0-1, Obilazak mjerne postaje-program template.ott")
    .DataSourceName =  "Status postaja" 'database name
    .CommandType = 2 '0=Table, 1 = predefined query, 2 SQL
    .Command = "SELECT ""Postaje"".""Postaja"", ""Obilasci"".""Datum obilaska"", ""Djelatnici"".""Ime"" || ' ' || ""Djelatnici"".""Prezime"" AS ""Osoba_IP"", ""Obilasci"".""Elek ploča"", ""Obilasci"".""Elek ploča napomena"", ""Obilasci"".""Gašenje"", ""Obilasci"".""Gašenje napomena"", ""Obilasci"".""Alarm"", ""Obilasci"".""Alarm napomena"", ""Obilasci"".""Klima"", ""Obilasci"".""Klima napomena"", ""Obilasci"".""Mrežni preklopnk"", ""Obilasci"".""Mrežni preklopnik napomena"", ""Obilasci"".""UPS"", ""Obilasci"".""UPS napomena"", ""Obilasci"".""Temperatura"", ""Obilasci"".""Vlažnost"", ""Obilasci"".""Kontejner"", ""Obilasci"".""Čišćenje"", ""Obilasci"".""Meteorološki krug"", ""Obilasci"".""Razno"" FROM ""Obilasci"" INNER JOIN ""Postaje"" ON ""Obilasci"".""ID_Postaja"" = ""Postaje"".""ID"" INNER JOIN ""Djelatnici"" ON ""Obilasci"".""ID_Djelatnici"" = ""Djelatnici"".""ID"" WHERE ""Obilasci"".""ID"" = " & oControl.Value 
    .execute(Array())
    .dispose
end with
2017-01-25 23:43:37 +0200 badge ontvangen  Populaire Vraag (bron)
2017-01-25 12:10:47 +0200 reageerde op een vraag Mail merge does not work

I discovered that by exchanging the code at the end with doc= .execute(Array()) doc.getCurrentController().getFrame().getContainerWindow().setVisible(true) window does show, but the fields are still not populated (actually they disappear)

2017-01-25 11:41:26 +0200 badge ontvangen  Leerling (bron)
2017-01-25 08:14:39 +0200 badge ontvangen  Beroemde vraag (bron)
2017-01-24 12:08:13 +0200 badge ontvangen  Redacteur (bron)
2017-01-24 11:37:25 +0200 badge ontvangen  Opvallende Vraag (bron)
2017-01-24 01:05:09 +0200 badge ontvangen  Populaire Vraag (bron)
2017-01-24 00:27:41 +0200 badge ontvangen  Student (bron)
2017-01-23 23:25:01 +0200 bewerkte een vraag Run "data to fields" from macro

Hello, I am automating writer from base by using macros (basic). I already have prepared writer template with connection to database and inserted fields. This procedure is I believe commonly referred to as "mail-merge", although, I would not call it like that, since I did not use mail-merge wizard, but "Data sources" from view menu and manually chose database fields. Anyway, I would like to populate these prepared fields (database fields) with record obtained from query from database (already set).

So, I just need to know how to programmatically select the first record in a query (it is the only record) and start "data to fields" action from a macro. Please see image below, the fields which should be populated with data from database are grey-colored.

image description

Thanks!