Subject Re: [firebird-support] Re: Another incompatible query generation of provider
Author Thomas Steinmaurer
> Monday, January 9, 2012, 12:06:09 AM, you wrote:
> m> Yes Dmitry, the Firebird Dot.NET provider is generating Apply code
> m> and as we know the server don't know how to process it.
> Firebird .Net may generate some code, but you mixing it up with your
> code with "OUTER APPLY", wich have completely nothing related with
> Firebird .Net driver.
> Keep in mind that Firebird .Net driver designed to work with Firebird
> only, and, if it generates some code that Firebird does not
> understand, this may be only the result of some bug in Firebird .Net
> driver.
> Since I know that author of this driver (Jiri Cincura) uses this
> driver in his applications, I seriously doubt that he (Jiri) wrote
> driver for Firebird incompatible with Firebird.
> m> As Jiri {x2} Cincura said, I need to rewrite my code because there is no way to Firebird solve
> m> this situation. I did rewrite my code and find a way to what I need. :)
> I'm glad to hear this. So, as I understand, it was your application
> that generated code incompatible with Firebird and compatible with MS
> SQL. Yes?

OUTER APPLY is a SQL Server thingy:

With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist