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:
http://technet.microsoft.com/en-us/library/ms175156.aspx



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

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/