Check field for numeric value

[tusharguptait]

Hi,

How can a field be checked for valid numeric value? I used database validation tab to set 'strict data type' as numeric only. But during import (using script) it added the records with field empty for invalid values. Isvalid() function takes value as 'B3' as valid.

Another step I tried :

GetAsText($TEMP_1) ≠ (($TEMP_1 + 1) - 1)

where $TEMP_1 contained the field value. This worked for all cases except where zeros are prefixed with number. Example: '011'.

I need to throw a error if any invalid numeric value is encountered. Any suggestions?

Regards

Tushar