Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore default value to fields?
Message
From
02/09/2006 18:11:40
 
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:
01150564
Views:
25
>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???
>
no. if true, then vfp it would produce an error because default is undef.

It don't do this, and it is a bug for me.

>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?
>

no.

if it can help:
...
APPEND FROM textfile.txt 
BLANK ALL FIELDS ... DEFAULT
>TIA
>Michael
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform