HomeFlySpeed SQL QueryParameters names limitations

Parameters names limitations


Hello,

I tried to execute a query like this:

SELECT
*
FROM
TABLE
WHERE
(TABLE.FIELD1 = :Value) OR
(TABLE.FIELD2 = :Value)

Is seems that using same parameter name in two different conditions (that requires the same value) generates incorrect results (only one condition is satisfied or, if the query is complicated, the second parameter is incorrectly typized, resulting in no result or error). All goes well if I use this syntax:

SELECT
*
FROM
TABLE
WHERE
(TABLE.FIELD1 = :Value1) OR
(TABLE.FIELD2 = :Value2)

assigning the same value to both parameters. So the question is: is this a design choice or a real bug?

Thanks in advance for any reply.
Stefano Gibellini | email
December 14 2009, 10:38 AM
Dear Stefano,

Thank you for your bug report. This problem is fixed. Please download the updated build.
Sergey Smagin | email
2 weeks, 2 days since original post
This topic is closed