Apache OpenOffice (AOO) Bugzilla – Issue 27416
ParameterNameSubstitution doesn't work for filter
Last modified: 2017-05-20 10:48:12 UTC
ParameterNameSubstitution doesn't handle a parameter name in form control's "filter" field. The error message is (from unixODBC 2.2.5 + postgresql 7.3.4), [unixODBC] The # of binded parameter < the # of parameter markers; Unrecognized key passed to PGAPI_GetInfo.
Hi, Say it in other words: The form property FILTER doesn't handel Parameter, like "FIELD1 = :var1" Bye Marc
->oj: yours
The statement which is generated when excuting a sub form with a filter is e.g. SELECT * FROM "public"."subtable" WHERE ( ( "b" = :id2 ) AND ( "id" = :link_from_id2 ) ) A second parameter is appended which raises the error. The filter condition should be looked for already defined parameters.
Reset assigne to the default "issues@openoffice.apache.org".