I am trying to migrate an MS-Access application to LibreOffice. I got
all tables transferred, now I am working at re-making all forms and reports.
I get stuck on this.
Table "Gezinnen"
3 columns:
gezinsid primary key autonummer
gezinsnaam varchar
huwelijksdatum date (in english marriage date)

Now I want to make a query with a parameter  which should refer to the
month of huwelijksdatum,
the query reads as

select "gezinsnaam", extract(month from "Gezinnen"."huwelijksdatum")
from "Gezinnen";
that works OK

now adding the parameter:
select "gezinsnaam", extract(month from "Gezinnen"."huwelijksdatum")
from "Gezinnen" where extract(month from
"Gezinnen"."huwelijksdatum")=:huwmaand;
When I run this, I get the dialogue to ask for the value of huwmaand,
but whatever I tried, just a digit, or # around it as a date or " or ',
I always get "Incorrect type for setString".
I'm at loss as I read in the Firebird FAQ (or whatever it is from
Firebird) that extract(month......) returns a smallint, so where do I go
wrong??

I tried to get around this by saving the first select as a query, works
OK and then opening a second query which takes the first as its source,
and add the parameter there, but no success.

BTW: I do this on Win10, but using the the same odb on Linux Mageia 6
with the same version of LibreOffice gives the same result.

Regards

Herman Viaene

--
Plus je dors, mieux je me porte (Gaston Lagaffe)

Hoe meer ik slaap, hoe beter ik me voel (Guus Flater)

The more I sleep, the better I feel (Gomer Goof)