Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Finding field information similar to AFIELDS()
Message
De
01/02/2001 16:41:05
 
 
À
01/02/2001 16:31:21
Robert Zinn
Made2Manage Systems, Inc.
Indianapolis, Indiana, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00471467
Message ID:
00471474
Vues:
10
>I need to find out information about a field in a table. However, this field may not be in my currently selected table, and I do not want to use AFIELDS because it returns too much information to wade through. Specifcally, I need to know the type, size, and (if applicable) decimal precision of my field. I haven't found a native VFP function that will provide this information for a single field. A simple UDF seems to be my next option, so any suggestions in that direction would be appreciated.

Sorry, AFIELDS() is one of the few ways that can return all the information about a field like width and precision for numeric fields. You can get the number of decimal places, but not the width of a numeric field:
nWidth = 20
nDecimals  = nWidth - RAT(".",PADL(numericfield,nWidth))
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform