1

I try for more than a week to fill out a SQL query parameter by running a macro on the "Fill Parameters" event in the subform by searching for a method to fill the parameter under the Parameters object with MRI without success.

Searches for guides and code samples on Google and the relevant forums also found nothing.

Have I missed something or am I looking in the wrong place? Thanks in advance!

Sql query:

SELECT * FROM "Table1" WHERE "Record-Id" = :Record-Id

Macro code to display an event object in Python:

def main (oEvent):
   ctx = XSCRIPTONTONT.getComponentContext ();
   mri (ctx, oEvent);
Bill Hileman
  • 2,798
  • 2
  • 17
  • 24
Sagi Nadav
  • 295
  • 1
  • 3
  • 14
  • You [also posted here](https://ask.libreoffice.org/en/question/154154/best-way-to-run-macro-on-libreoffice-or-openoffice-subform-fill-parameters-event/), and @Ratslinger's answer is a good one. – Jim K May 07 '18 at 13:06
  • @JimK I already have a much better solution than the improvised solutions I got there, I will publish it here soon. – Sagi Nadav May 08 '18 at 03:49

0 Answers0