On 16-9-2019 15:35, Herman Viaene herman.via...@edpnet.be [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
