From The Document Foundation Wiki
Jump to navigation Jump to search

When I open a main form containing a sub-form, an error appears stating that the number of parameters does not correspond(ODBC/JDBC connection)

Some database drivers do not allow the user to carry out queries with names parameters. For example : SELECT * FROM TABLE_X WHERE ID=:id. In this example, :id is a named parameter, but the driver returns an error message that no such parameter exists.