Calling a route from programmatically created form

[marus_b]

To avoid XY question problem, let me explain what the goal is first. I’m creating a front end to a database and I’d love to eliminate the flickering which occurs while forms load and unload. Thus, I came up with an idea of using simply one form, and programmatically create/destroy controls, register events, etc. as I require.

Problem which I’m dealing with is that when I am trying to register an event, it looks for the routine in the form document, instead of my database file where my code is. If I change the URI “location” parameter from “document” to “application” and place my routine in “My Macros & Dialogs” then everything works fine. Thus, the question that I am dealing with is if at registration of an event the URI of:

vnd.sun.star.script:LibName.ModName.FileName?language=Basic&location=document

can be changed to be pointing back to my database file library.modules?

Thank you very much for any suggestions and guidance.

[Villeroy]

The StarBasic variable ThisComponent refers to the active document whereas ThisDatabaseDocument refers to the embedding database document of an embedded form.
No matter where you put the code:

Sub my_FormEvent(ev)
    oForm = ev.Source
End Sub
Sub my_ControlEvent(ev)
    oControlModel = ev.Source.Model
    oForm = oControlModel.Parent
    REM in case of a column within a table control calling:
    oForm = oControlModel.Parent.Parent
End Sub

The following function walks the form hierarchy from the given object up until the matching element.
Embedding database document: com.sun.star.sdb.OfficeDatabaseDocument
Form document: com.sun.star.document.OfficeDocument
Draw page: com.sun.star.drawing.GenericDrawPage
Forms collection: com.sun.star.form.Forms
Parent form: com.sun.star.form.component.DataForm

Function getParentObject(byval m, srvName$)
on error goto NullObj
	do until m.supportsService(srvName)
		m = m.getParent()
	loop
	getParentObject = m
	exit function
	NullObj:
	getParentObject = Null
End Function

[marus_b]

@Villeroy To begin with, I have accidentally flagged your post, my sincere apologies if that creates any problems.

I deleted my original response, and I have included a sample code
event routine calling issue.odb (4.7 KB)
. The problem can be recreated by running “createCanvas” routine, and then clicking the button which appears

There event is bound to a button which is programmatically created into a new writer document, from a database file code. I am under the impression that the event is looking for the routine everywhere within the writer document framework.

The workaround which gave me positive results was creating an empty form, in advance, and utilizing it. Which leads me to believe that if there is no way of altering the URI to include the fully qualified path before the library.module.routine then the former is the only solution I have. Otherwise, maybe putting the code into a writer/calc file instead and then connecting to my database without using Base file would be a more viable approach?

I’m getting the following error message:

Version: 25.2.6.2 (X86_64) / LibreOffice Community
Build ID: 729c5bfe710f5eb71ed3bbde9e06a6065e9c6c5d
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26200); UI render: Skia/Raster; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: threaded

[marus_b]

I’ve created a form, replaced a few lines of code and I’m back in business. However, it would be still nice to know if there is/are an alternate solution(s) to this.