>but when i use TYPE() to check the data type of the field , it return "U"
>My code:
>ret = TYPE(table.field)

That table has to be open when you do this, and you have to enclose the field in quotes:

ret = TYPE("table.field")