On 16-9-2019 15:35, Herman Viaene herman.viaene@...
[firebird-support] wrote:

> 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.

[..]

> 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 think this is more a support question for LibreOffice, and how they
use prompts for parameters and set parameters in a query. It seems they
unconditionally use a string setter on their statement object, but
disallow setting as string on a numeric type.

This would need to be fixed in LibreOffice itself (either by using the
correct setter for the type, or be supporting conversion in this situation).

Mark
--
Mark Rotteveel