Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Setting default field value in vfp dbc
Message
De
01/01/2007 13:33:44
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Setting default field value in vfp dbc
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Novell 6.x
Database:
Visual FoxPro
Divers
Thread ID:
01181228
Message ID:
01181228
Vues:
70
Greetings and happy new year
I have a field: name=GlApNum, type=character(6). I would like to assign the value 002010 to the field. If I enter 002010 I get a data type misMatch and it truncates the leading zeros. If I enter "002010", when I dbGetProp, it returns the value "00201. If I enter str(002010), dbGetProp returns str(00. I have the same problem in the properties field and find it necessary to code assign_GlApNum. I can of course remove the "s, but I feel there has to be a way to enter the string value 002010.

thanks, vince
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform