Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting default field value in vfp dbc
Message
From
01/01/2007 13:33:44
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Setting default field value in vfp dbc
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Novell 6.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01181228
Message ID:
01181228
Views:
69
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
Next
Reply
Map
View

Click here to load this message in the networking platform