>>Hello,
>>
>>I need to know the size of fields, and I use FSIZE() for this. THis works fine, for example when a field is N(10), it returns 10. Now I have a table where a field is Integer (I) and FSize() returns 4, although the actual length of the field is 10 digits. So I want to get 10 when the field is an integer. How can I find this out?
>>Thanks for help in advance!
>
>
>You will get 4 with an Integer type field because an integer is store as a 4-byte binary value. If you want the number of digits stored in a integer type field you might try Len(AllTrim(Str(fieldname))). This will get the number of digits.
this gives you the lenght ofthe CURRENT value of the field. Len(AllTrim(Str(256^4)))will give you 10 (the biggest Integer is 4,294,967,296 , half of that is for negatives.and you also need to account fot the minus sign,which makes it a length of 11. Peter
>
>Hope this helps.
Peter Cortiel