Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore default value to fields?
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Restore default value to fields?
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01150539
Message ID:
01150539
Views:
78
I'm doing an APPEND from a text file to a table, and I have defined a Default Value for one of the table fields - but the field remains blank after the import.

The default value includes the concatenation of other fields.

I presume VFP doesn't have the other field values until the record is imported - and by that time it's too late to calculate the default value???

Anyway... is there any way for me to force all those empty fields to be populated with the default value I have defined for the field?

TIA
Michael
Kogo Michael Hogan

"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?

Ideate Web Site
Next
Reply
Map
View

Click here to load this message in the networking platform