The way how passed (named/positional) paramaters are represented in a resulting SQL command is determined by a parameter's type.
If the parameter's type is String than it ends up in query as string wrapped in quotation marks.
So for example String: #11:0 passed as parameter will end up in query like this: "#11:0", which is not a right format for a record identifier in a query.
On the other hand the parameter of type ORecordId will end up in query as ID without quotation marks, which is the right format for record identifier in a query.
However if you use string concatenation to build your SQL query instead of passing parameters, than concatenating string #11:0 is fine, because you're not concatenating any additional quotation marks into resulting query string (that would be neccessary for example for property value of a string type).
Dne sobota 3. října 2015 15:33:28 UTC+2 Tsadok Levi Firseck napsal(a):