0.00 is greater than 0 in text field

[daveinc]

Any idea why 0.00 is greater than 0 when it is in a Text field? When I do a Replace Field Contents   

 

If ( Table::f2 > 0 ; something happens )

 

and Table::f2 is a Text field, it evaluates as greater than 0 and "something happens". Why?

[Raybaudi]

0.0 is > 0 exactly as A.A is > A: they sort that way when in a text field.

 

Try: 

 

If ( GetAsNumber ( Table::f2 ) > 0 ; something happens )

[daveinc]

Raybaudi,

I have a script with 256 Replace lines in it for 256 fields. I was trying to not have to do all of the editing. I just changed the text field to number 256 times, slightly easier than changing all of the Replace lines. It defaulted to text field type because of the original import from a tab file. Thanks for the reply.

[comment]

I have a script with 256 Replace lines in it for 256 fields.

 

I suggest you re=examine your structure - it sounds like you should have 256 related records instead.

[Vaughan]

It defaulted to text field type because of the original import from a tab file. Thanks for the reply.

 

Make a backup of the file, then change the field(s) from text to number type. See if the problem is solved.