Hi All,

There is a strange issue that I faced. There is an active link which has a Direct SQL which calls a procedure which passes '$NULL$' as a parameter.

When the same active link was converted to filter and with the same '$NULL$' as the parameter, it started appearing as '$--1$' in the logs.

I checked up the FILTER_SQL table and it seems to have the Direct Sql Stored with the $NULL$ value as $--1$.

Is there any reason why this is the case?

Is this how it works in the case of filters?

Why doesnt it gat the NULL value in the logs ??
Please help.

Vivek

Keywords are internally stored as $-number$. You will see this in def or makro definitions.

The question is do you really need '$NULL$' as a parameter? If you want null let the parameter empty.