Error with subform
Posted: Tue Feb 26, 2019 6:02 pm
I connect Libreoffice (6.1.5.2) Base to a database in PostgreSQL (11.2) via JDBC.
I made two forms with subforms without any issue. Now I get an error with the third form with subform. I created the form and subform by using the Form Navigator, specified the master and slave fields, saved the forms. Everytime when I open the form, the error message pops up, saying:
"Replace named parameters with '?'" has been ticked.
Thanks in advance for any help.
I made two forms with subforms without any issue. Now I get an error with the third form with subform. I created the form and subform by using the Form Navigator, specified the master and slave fields, saved the forms. Everytime when I open the form, the error message pops up, saying:
Further, the SQL Status is 42883.The data content could not be loaded. ERROR: operator does not exist: integer = character varying Hint: No operator matches the given name and argument types. You might need to add explicit type casts. Position: 92
"Replace named parameters with '?'" has been ticked.
Thanks in advance for any help.