Devart Forums

When I open the table on AS/400 that has set the parameter MasterSource I get the error SQL0417 with the current version of UniDAC (with old versione worked).
What can I do to solve it?
Best regards
Giovanna Cellitti

Hello,

Please provide the error message or its screenshot.

This is the error:
SQL0417
A statement string to be prepared contains parameter markers as the operands of the same operator.

I see this difference with DbMonitor:

First:
SELECT * FROM CFRIC
WHERE (CRANNO=2014 AND CRNUME=2)
AND CRANNO=:CPANNO AND CRNUME=:CPNUME

After the string CRANNO=:CPANNO has been replaced with:
(CRANNO=:CPANNO) OR ((CRANNO IS NULL) AND (:CPANNO IS NULL))

Bye
Giovanna

Generating of such a SQL query is due to the support for NULL values in fields involved in master-detail relation. From the next release, a separate option (disabled by default) will be responsible for generating of such a query.