IsNull on stage variables

[pimmit22043]

i'm trying to use the IsNull on the stage variables ,it is giving the compiling error,

is there any thing i can use to do the isNull on stage variables.





Thanks

[JoshGeorge]

You should be able to use IsNull() on stage variables. Post the compilation error you are getting, that might say more to investigate.

[krishobby]

If you have a stage variable var1 you can have an expression like this,

If IsNull(col1) then ...

But you have another stage variable var2 you [u]cannot [/u]have an expression like

If IsNull(var1)

[JoshGeorge]

Righlty said. You can use IsNull() or IsNotNull(), say any Null Handling functions in a stage variable. But the input to these functions cannot be a stage variable, regardless of where you are using these funtions.