>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!
The field won't always be ten digits. It'll depend on the value of the integer. Integer fields can store values between -2147483647 and 2147483647. They're stored in 4 bytes in a LSB to MSB format.
George
Ubi caritas et amor, deus ibi est