I'm using libreOffice Base as a graphical frontend to PostgreSQL database. Within the PSQL database is a self-written function, 'search(parameter1, parameter2)', which returns a table. I now want to have a form with two input textfields, a button and a table (grid). The content of the input textfields should be used as the parameters for the PSQL function 'search' and on button press, I want to display the result of that function in the table.
So far I am able to read the values from the textfields in a macro with something like
Code: Select all
parameter1 = oForm.getByName('InputPara1').Text
parameter2 = oForm.getByName('InputPara2').Text
Code: Select all
oSQL_Statement.executeQuery
Greetings