Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with FSIZE()
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00393504
Message ID:
00394263
Vues:
10
You're correct on the first part. But - a minus sign will not increase the length of an integer, it takes up one bit. Therefore, the value of a signed integer ranges from -2,147,483,647 to +2,147,483,647. The value you specified is for an unsigned integer (VFP doesn't have unsigned integers). The biggest unsigned integer would actually be one less than you said (you forgot the zero value).

>
> 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.
Nigel B Coates
NBC Software Services
Dublin, Ireland.
eMail: Nigel.Coates@NBCSoftware.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform