Hi

See the attatched screenshot:

- IF dataset.abonnement = "Mi3G" Then display dataset.abonnement

This is triggered, also when dataset.abonnement is NULL (as you can see in the example - if it were really "Mi3G", that text would apear in the message box)

This happened when I switched to Microsoft SQL Server 2008 Express R2, and it only happens when the value is null, or when no records are found (it it FINDS a record with a value in dataset.abonnement, it works fine ..)

Category Survey

Morten,
it appears that Automate's IF does not handle properly the Null variables.
As demonstrated in the sample below.
A workaround is also shown, with an additional testing of the var with NOT IsNull

Category Survey

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMVARIABLE NAME="a"></AMVARIABLE> <AMSCRIPT>Sub Main a = Null End Sub </AMSCRIPT> <AMIF EXPRESSION="a = &quot;Mi3G&quot;"> <AMMESSAGEBOX>%a%</AMMESSAGEBOX> </AMIF> <AMIF EXPRESSION="a= &quot;Mi3G&quot; and not isnull(a) "> <AMMESSAGEBOX>a</AMMESSAGEBOX> <AMELSE /> <AMMESSAGEBOX>not equal to Mi3G</AMMESSAGEBOX> </AMIF>

-------------------------
Jean Delfosse - Automate Beta Tester
Win7 Pro 64 bits -Win XP Pro SP3 32 bits - AM8, AM7, BPA10, BPA9, BPA8, BPA7, AM6 Enterprise, AM4

Did this ever get fixed? I'm evaluating an expression for Null and it doesn't seem to recognize it. I also tried " " and no luck.

Category Survey

Hi Brian,

We are currently trying to determine if this has been addressed in BPA8. If it still remains an issue, it will be documented and corrected as soon as possible.

Category Survey

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665