Hello, just updated to r1233
i think there is a typographical error
return SqlStatement.Format("{0} || {1})", a, b);
there is an extra ")" in which made the syntax wrong
________________________________
From: Jonathan Pryor <[email protected]>
To: [email protected]
Sent: Fri, October 9, 2009 3:16:15 AM
Subject: [dblinq] Re: CONCAT in Firebirdsql error
This has been committed as of r1233.
Thanks!
- Jon
On Sun, 2009-10-04 at 11:18 -0700, Erickson wrote:
> i found a simple bug, in which i cannot use Contains, StartsWith and
> several String filters and found thisin DBlinq.Firebird
>
> under FirebirdSqlProvider.cs
>
> change this
>
> protected override SqlStatement GetLiteralStringConcat(SqlStatement a,
> SqlStatement b)
> {
> return SqlStatement.Format("{0} || {1}", a, b);
>
> }
>
> previously it was
>
> protected override SqlStatement GetLiteralStringConcat(SqlStatement a,
> SqlStatement b)
> {
> return SqlStatement.Format("CONCAT({0}, {1})", a, b);
>
> }
>
> it was returning an error that CONCAT function is unavailable in
> Firebird,
>
> check this: http://www.firebirdsql.org/manual/qsg2-databases.html#d0e4490
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en
-~----------~----~----~----~------~----~------~--~---