Hi, I just saw that the query and the execution do not match correct. This is the query with the parameter that creates an exception if the parameter is "Halle 6 - Schlosserei".
ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND AUSLASTUNG_GEHOERT_ZU = {0} ORDER BY PRODUKTIONSAUFTRAG_ID"; tmpPPA = this._ctx.LPP_PRODUKTIONSAUFTRAEGE.SqlQuery(ppaQuery, this.CurrentHalle).ToList(); Niko -----Ursprüngliche Nachricht----- Von: Jiří Činčura [mailto:j...@cincura.net] Gesendet: Dienstag, 2. Mai 2017 09:43 An: firebird-net-provider@lists.sourceforge.net Betreff: Re: [Firebird-net-provider] EF handling - as string parameter What parameter? I don't see any parameter in the query. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider