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

Reply via email to