Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore default value to fields?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01150539
Message ID:
01150571
Views:
22
Michael,

If your table is in a DBC then you can do this by calling a stored procedure to calculate the default value and not have to worry about always coding it.

-Dan

>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
Previous
Reply
Map
View

Click here to load this message in the networking platform