Problem: A SQL statement yields unexpected results in runtime.
Explanation: This may happen when you use a non-Sybase database, and include a comparison operator in a definition SQL statement followed by a parameter; for example: "select * from ... where columnA=:parameterA, and the default value of this parameter is set to null.
Solution: If you need null as the default value, define an object or operation and manually write the definition SQL statement (for example, " columnA is null") in the Property view.