On Thu, May 9, 2013 at 5:34 AM, Muthu Annamalai
<pearlamer...@hotmail.com> wrote:
> Firebird is throwing this exception
>
>
>
> SQL error code = -104
>
> Token unknown - line 35, column 4
>
> OUTER ---&gt; Dynamic SQL Error
>
> SQL error code = -104
>
> Token unknown - line 35, column 4
>
> OUTER
>
> at
> FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior
> behavior)
>
> at
> FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior
> behavior)
>
> at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
>
> at
> System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand
> entityCommand, CommandBehavior
> behavior)</ExceptionString><InnerException><ExceptionType>FirebirdSql.Data.Common.IscException,
> FirebirdSql.Data.FirebirdClient, Version=3.0.2.0, Culture=neutral,
> PublicKeyToken=3750abcc3150b00c</ExceptionType><Message>Dynamic SQL Error
Yes. This query is very likely to end up with OUTER APPLY in the
generated statement and this is not supported by Firebird (yet). You
have to rewrite the query.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and
their applications. This 200-page book is written by three acclaimed
leaders in the field. The early access version is available now.
Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
