> I "linked" the two fields for the subform and when I execute the form, I
> get the error message:
> SQL Status: HY000
> Error code: 1
> parameter marker count incorrect
Could be you have written 2 fields for the mainform and one field for
Other possibility: There are parameters in the query of the subform. You
have more parameters than connected fields from mainform and subform.
I've been banging away at this problem and I don't think the problem is
at the ODBC level but LOs attempts to generate SQL statements correctly.
I don't have the wherewithal to isolate the problem further than to have
seen an error in the code (sqllite SQL request string) so I'm trying to
simplify an example with a subform but that's about the best I can do at
Let's get this out of the way:
/*Before anyone states the obvious, the example I'm using is /NOT/ in
need of rewriting, it is an example to prove that there's a problem. It
is a vastly simplified version of a much larger form I was in the
process of building.*/
In short. I simplified the problem so that it is one table that points
to another and it's a one-to-many relationship. The example is a
computer model pointing to installed models.
The LO SQL generated has a strange reference to a link in it that makes
no sense from a SQL point of view.
As far as I can tell the error comes from LO. It is well within reason
that the problem is caused by my incorrect design but it seems a stretch
at this point.
Here's the SQL statement (reformatted) I got in the trace of the ODBC
"SystemModels"."SystemModel" AS "SystemModel",
"SystemModels"."SystemMfg" AS "SystemMfg",
"SystemModels"."SystemMfgName" AS "SystemMfgName"
( "SystemModels"."SystemModel" =:link_from_SystemModel )
That last line has the problem. :(
I'm going to do some tests to see if it really is my form that is
causing it but that seems like a stretch.
Passing this on for general knowledge and in an effort to help others.
> Here's the SQL statement (reformatted) I got in the trace of the ODBC
> library call:
> "SystemModels"."SystemModel" AS "SystemModel",
> "SystemModels"."SystemMfg" AS "SystemMfg",
> "SystemModels"."SystemMfgName" AS "SystemMfgName"
> "SystemModels" "SystemModels"
> ( "SystemModels"."SystemModel" =:link_from_SystemModel )
> That last line has the problem. :(
Could be there are Problems with named parameter.
Open The *.odb-file.
Go to Edit → Database → Advanced Settings
Choose "Replaced named poarametr with '?'"
Hope you find "named parameter" there. The menue is different for