GetAsBoolean not working

[charlest]

Having problem using GetAsBoolean.

 

My understanding is a text field will evaluate to "0" if the field is empty or the value is 0, and evaluate to "1" if the field contains any other value.

 

All fields I am trying to evaluate are text fields on the same layout with the correct table occurrence.  The results as shown in the dataviewer do not evaluate as I would expect.  The company name, streetaddress2, city and state all evaluate as if the field was empty, only the customerid and streetaddress2 appear to evaluate correctly.

 

Any thoughts on why these fields would evaluate as empty?

 

 

 

 

[bruceR]

Not sure where you got that understanding regarding GetAsBoolean but it isn't correct and you are seeing the expected results.

 

Are you actually trying to calculate whether fields are empty? Then you should be using isEmpty().

[charlest]

Got it.  I misread the description about the function reference.  I am trying to determine if the field is empty or contains a zero.  I will use is empty and have a separate test for zero.

 

Thanks.

[comment]

I am trying to determine if the field is empty or contains a zero.

 

All your fields shown are Text fields. What is the significance of a Text field - such as company name, streetaddress, city or state - containing a zero?

[charlest]

In addition to those text fields I have a few numeric fields that I need to know if they are empty or contain a zero.  I guess getasboolean would work for those fields and I would not need to a separate test to see if the field is empty.

[comment]

That is correct.