Kbase P53310: ODBC : "IS NULL" not supported for parameter values - "Syntax error"
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
MERANT 3.60 32-BIT Progress SQL-92
DataDirect 4.1 32-Bit Progress SQL92 9.1D
SYMPTOM(s):
Syntax error (7584)
SQL-92 query contains "IS NULL" condition for a parameter value,
for example in WinSQL:
SELECT * FROM pub.customer
WHERE ("Address" = ::myparam
OR ::myparam IS NULL
AND "Address" IS NULL)
For example, VS.NET 2003 - Windows Form Designer generates UPDATE and DELETE statements containing this unsupported syntax.
CAUSE:
Progress does not support "IS NULL" syntax with parameter values
FIX:
For character values, you can use IFNULL function instead,
for example in WinSQL:
SELECT * FROM pub.customer
WHERE ("Address" = ::myparam
OR IFNULL(::myparam, '') = ''
AND "Address" IS NULL)
For numeric values, there is no known work-around at the moment.