SCAuto event maps

[tommy]

Can someone tell me whats wrong with this.

I have an event with an associated event map. In this map I have among other things following 2 fields:

ext.error.num
ext.error.text

both fields are defined as characters in the dbdict

On the map for ext.error.num I have following expression in post-map instructions:

if null(ext.error.num in $axces.target) then (ext.error.num in $axces.target="0")

This should ensure that the field will be filled with "0" if the field is NULL in the event. This WORKS.


On the map for ext.error.text I have following expression in post-map instructions:

if null(ext.error.text in $axces.target) then (ext.error.text in $axces.target="Ok")

This should ensure that the field will be filled with "Ok" if the field is NULL in the event. This does NOT WORK!

Except for the actual field names the to maps is completely identical.

[thephantomlord]

Tommy,

There doesn't appear to be anything wrong with your statement but you could try writing like this instead:

if ext.error.text in $axces.target=NULL then (ext.error.text in $axces.target="Ok")

That's typically how I check for null in my format control records.

Aaron

[tommy]

The really painful thing about SC generally is that following statements all in theory should give the same result:


if ext.error.text in $axces.target=NULL
if null(ext.error.text in $axces.target)
if same(ext.error.text in $axces.target,NULL)

But You nerver know when which one will work :evil: