Re: [Firebird-net-provider] The provider is creating incompatible code to Firebird

2012-01-08 Thread Jiri Cincura
You have to rewrite your query. CROSS APPLY is currently not supported by server and there's no direct (general) rewrite with other operators. :( -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -

[Firebird-net-provider] The provider is creating incompatible code to Firebird

2012-01-07 Thread Marco Aurelio Castro
Hi, I find a situation that Firebird's generated code don't run because the CROSS APPLY is used. The issue is generated because I need to create a query inside the where clause. I'll show the code that runs and part of the code that brings the issue, ITENS_ENTRADA.**Where(w => (w.PRODUTOS.**ESTOQ