Subject | Re: [firebird-support] LIKE clause trough ODBC: expression evaluation not supported (SOLVED!) |
---|---|
Author | Mimmo |
Post date | 2004-06-26T18:41:55Z |
<snip>
(3.0) maybe obsolete.
I've found in the code a small segment that parse every query, and
sobstitutes " || " in " + ". Commenting that code solved the problem.
Many thanks, anyway.
Mimmo.
> SELECTAfter sending previous e-mail, immediatly suspected that my ODBC docs
> Tbl1.Fld1 AS t1xxx,
> Tbl1.Fld2 AS t1yyy,
> Tbl2.Fld3 AS t2zzz,
> Tbl2.Fld4 AS t2kkk
> FROM Tbl1, Tbl2
> WHERE Tbl1.Fld1 = Tbl2.Fld1
> AND ( Tbl2.Test1 = 'N' OR Tbl2.Test2 = 'P')
> AND Fld3 LIKE ? + '%'
> ORDER BY Fld3
(3.0) maybe obsolete.
I've found in the code a small segment that parse every query, and
sobstitutes " || " in " + ". Commenting that code solved the problem.
Many thanks, anyway.
Mimmo.